Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paulkem
Starting Member
28 Posts |
 Posted - 2014-01-08 : 15:16:44
|
| 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? Paul |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-09 : 05:10:41
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
paulkem
Starting Member
28 Posts |
Posted - 2014-01-09 : 07:55:09
|
| 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.PK |
|
|
|
|
|
|
|
|
Alternative for Report Header Display in Subreport