Creating Static Headers on SSRS reports.

Hi,

Today we gonna learn how to create static headers on every page of SSRS reports which are not report headers. Observe the below report page 2 which does not have report header since it is visible only on page 1.

report6

To make header visible on every page, follow the below steps:

  1. Click the Columns Group à Click Advanced Mode as shown below:report9
  2. After clicking on Advanced Mode, you find multiple entries in Row Groups and Column Groups as shown below:report10

    Click on Static which is present in Row Groups and browse the tablix member properties named as RepeatOnNewPage = true, KeepWithGroup = After.That’s it. Now execute the report and it is as shown Page1 and page2.

    report7report8That’s it for the day. Enjoy..:)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s