Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Alternative for Report Header Display in Subreport
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

28 Posts

Posted - 01/08/2014 :  15:16:44  Show Profile  Reply with Quote
I have a report which is composed of 6 tables and utilizes several datasets.

The first two tables are on Page 1, are side by side, and are static in size.
The third table is at the bottom of Page 1 and is just a space holder to create a table that will be populated manually when the report is exported.
The fourth table groups by the concatenation of month and year, displaying 4 records for each grouping, with a blank row for spacing between the groupings. The size (length) of this table is dependent upon the date range that the user selects.
Table five also groups by the concatenation of month and year, with one record per grouping (and one footer row).
Table six is a straight detail table with no groupings, and is dynamic in size.

Right now, the report is set up with a date range and a single employee parameter. The report breaks in a logical fashion, and the report header displays the date range and employee name on each page. It works fairly well this way.

However, a request has been made to change from a single employee parameter to a multiselect, repeating the entire report for each selection. I thought I could create a report consisting of either a list or table, grouped by employee, and then nest the existing report as a subreport within this grouping (making neccesary changes for parameters). This worked, but I was very disappointed to learn that the report header does not appear in a subreport. Now I have no idea how to get the date range and employee name to appear on each page.

Anyone have any ideas?


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 01/09/2014 :  05:10:41  Show Profile  Reply with Quote
you can apply grouping on employeename inside your container which shows the data.
This will make sure data gets repeated for each employee in your dataset. then you can set option insert a pagebreak after to make sure each employee details gets displayed in a separate page when rendered.

SQL Server MVP
Go to Top of Page

Starting Member

28 Posts

Posted - 01/09/2014 :  07:55:09  Show Profile  Reply with Quote
I created a table, added a grouping on EmployeeNumber, and included a Group Header for the grouping. Within the Group Header I inserted the EmployeeNumber and then removed the default grouping column from the left and the column header. I removed the detail row, and any unused columns. Then, I added a row inside the group, below the EmployeeNumber. This is where I insert the subreport. On the Properties for this grouping, I have set the Page break options to "Between each instance of a group" and "Also at the end of a group". Is that what you mean?

This does not work. Yes, it shows the employee information at the top of each subreport "instance" but not at the top of each page.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000