Repeat row and column headers for each group
I have two row groups and one column group in my report.
Rowgroups columngro
group1
group2
details
I did page break by group1.originally,my report is in 2 pages.after the page break,report is in 11 pages.
I want to keep the each group data one after other with row and column headers for each group .
For eg:
In report first page:
col1 col2 col3
group1 data
col1 col2 col3
group2 data
if the group 3 data doesnt fit in the first page,
then it should be on report page2
col1 col2 col3
Group3 data
July 23rd, 2011 8:06pm
Hi,
Click on the matrix, and go its properties tab. Go to the Repeat Column Header property and make it true, it will repeat the header in all the sheets.
Regards,
Bharath R S
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2011 6:22am
Hi Sqlstar07,
Generally, there is no built-in feature to meet the requirement. But we can make full use of the flexible layout of a list.
One workaround here is:
1.
Drag the original table into a list.
2.
Right-click the list handle, select Tablix Properties.
3.
In Tablix Properties pane, in the DatasetName drop-down list, select the main dataset of your original table.
4.
Right click the Details group, and click Group Properties.
5.
In Group Properties dialog, click add to define a group for the details row.
Now, we can see the row header repeat for every group defined in step 5.
Thanks,
Lola Wang
Please remember to mark the replies as answers if they help.
July 25th, 2011 9:17pm