Report Design Question two horizontal column headers one below other

I have a report requirement, i am new to reports.

I want to have two lines of column headers.( with 7 columns in parent columns header)

and 7 columns in child column header.

The first column header will show a parent record.

And after the parent record i want to show the next child related horizontal column headers and will show all child record related to the above parent record.

its a one to many: 1 parent record and below all child records for that parent record.

can i use subreports controls to show all child records of the parent.

Thank you very much for the information.

I would recommend that you a table report

Assume that you have a structure

Country A

Region A1

Region A2

Country B

Region B1

Region B2

Region B3

In this scenario create a table that groups records by country. In the group header/footer (depending on your need) add a new table that contains regions associated with the country.

HTH.

Report Column Headers from Database table

Please is it possible to get the reports column names from database table via stored proc or a select query.

Because reports needs to be localized between spanish and english users, so if a spanish user is logged into the system, it must bring all spanish column names from DB table and show in the headers, same with english users.

Thank you very much for the information.

I am using SQL 2K Reporting services.

Are the column names from a different dataset than the rest of the data in the report? If so, you have the following options:

1. Modify the query to return them in the same dataset (since you can't use two datasets in the same table).

2. Modify the report to include two tables, one only has the table header for the column names, the other (without header) displays the detail data, and align them appropriately.

3. Use subreport embedded in the table to display the detail data.

sql

Report Builder - Table Triangles

When building a table in report builder from related entities, there appear two small upside-down moveable triangle flags above the column headers. Moving these flags seem to affect the automatic grouping and automatic joins of the table.

Does anyone know what this feature is called? I mean, it cannot really be referred to as "those triangle things." I've searched and cannot find any reference to it. Also, does anyone know how to really use this feature?

Thanks

These sliders control the equivalent of the "Freeze Panes" feature in Microsoft Excel. They should not affect the grouping structure of the table or the underlying query.

Report Access

I have created a new report that all my users except for one can print and
view the same data on this report. One user gets the
report headers -- but no data.
I checked this user's active directory settings, and she is a member of the
same Reporting Group.
What could be the problem?Sounds like SQL data permissions issue. If I understand correctly the user
is seeing text that is static in the report but no data from the dataset.
Is the dataset SQL a stored procedure, or a select statement. If it's a
select statement probably doesn't have access to read the tables. Try
loging onto query analyzer with the users credentials (or similar) and
seeing what data is returned.
Steve MunLeeuw
"Cindy" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:OHuLuAu7GHA.3644@.TK2MSFTNGP03.phx.gbl...
>I have created a new report that all my users except for one can print and
>view the same data on this report. One user gets the
> report headers -- but no data.
> I checked this user's active directory settings, and she is a member of
> the same Reporting Group.
> What could be the problem?
>|||Hello Cindy,
Does Steve's suggestion make any sense to you?
Also, you could try to test on other client with your user's credential. If
you could access the report on other client, you may need to check the IE
security setting.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)