Pages

Thursday, September 4, 2014

How to repeat headers in Report Builder/SSRS




Following is the process to repeat the headers on every page in the report Builder 

Select the arrow to the bottom right corner to get the advanced as shown in the figure.

Click on the Advanced  Mode Button in the Column Groups.Once you click the Advanced Mode you would be able to see the static rows in the row groups as shown below.
  

Select the header which you want to repeat on each page and set the properties KeepwithGroup to After and RepeatOnNewPage to True as shown below.


Apply the report properties to all the static rows that you want to repeat on every page.This should repeat headers on every page .


No comments:

Post a Comment