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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics