I wanted to Repeat header rows on each page in SSRS Reports. Since I had a report containing large number of transactions, I required to split the output into multiple excel sheets and with that repeat the header row on each sheet and on every page on Preview. For achieving this, I followed the below steps.
1) At first, checked 'Repeat header rows on each page' and 'Repeat header columns on each page'
2) Select the table and in right to the grouping pane, click the down arrow and then click 'Advanced Mode'.
3) In the row group pane, click the static tablix member and same will be highlighted in the table as well.
4) Now in the property window, for the static member in row group pane, set the following properties:
a) Set KeepTogether = True.
b) Set KeepWithGroup property as per your choice.
For static row above the group, set 'After'
For static row below the group, set 'Before'
c) Set RepeatOnNewPage = True
5) That's it. Save the changes and run the report and check the output.
Reference: Govind Badkur(http://sqlserver20.blogspot.com)
1) At first, checked 'Repeat header rows on each page' and 'Repeat header columns on each page'
2) Select the table and in right to the grouping pane, click the down arrow and then click 'Advanced Mode'.
3) In the row group pane, click the static tablix member and same will be highlighted in the table as well.
4) Now in the property window, for the static member in row group pane, set the following properties:
a) Set KeepTogether = True.
b) Set KeepWithGroup property as per your choice.
For static row above the group, set 'After'
For static row below the group, set 'Before'
c) Set RepeatOnNewPage = True
5) That's it. Save the changes and run the report and check the output.
Reference: Govind Badkur(http://sqlserver20.blogspot.com)
No comments:
Post a Comment