Sounds easy going by the usual way of Tablix properties and check the "Repeat header rows on each page". Strangely this didn't work for me today so I found out a new way for same.
Under Design Pane - > at the bottom Column Groups - > click on drop down (down arrow) - > Advanced Mode.
Once we selected Advanced Mode, we will be able to notice (static) in Row Groups and Column Groups at the bottom of Design pane .
Under Design Pane - > Row Groups - > click on (static) - > Press F4 - > Properties window will pop-up.
In the Properties window - >Set KeepWithGroup = After and RepeatOnNewPage = True.
If you want the header to be frozen while scrolling down the report, set FixedData = True.
Credit: http://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx
Under Design Pane - > at the bottom Column Groups - > click on drop down (down arrow) - > Advanced Mode.
Once we selected Advanced Mode, we will be able to notice (static) in Row Groups and Column Groups at the bottom of Design pane .
Under Design Pane - > Row Groups - > click on (static) - > Press F4 - > Properties window will pop-up.
In the Properties window - >Set KeepWithGroup = After and RepeatOnNewPage = True.
If you want the header to be frozen while scrolling down the report, set FixedData = True.
Credit: http://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx
No comments:
Post a Comment