Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSRS - Table Row Visibility onMultiple pages

  • 21 October 2013
  • Author: Surendra
  • Number of views: 8653
  • 0 Comments

SSRS Table Row Visibility on Each Page:

Step 1: we have health facility table in our report ,it contain health facility,ownership etc.. as headers

When we go to 2nd page ,these headers are not appeared and  only it appears the  detail level data.like follows.

Page 1:

 

Page2:

 

So in this report we want repeat row headers on each page like below

 

Step 2:

Right click on Column group button and select advanced mode

 

Then it will  appear as static group

 

Step 3:

Then we select row group and click on properties tab, then we find in properties window

Check it as true as mentioned below

1. KeepTogether               --------------True

2. RepeateOnNewPage  ----------------True

 

 

Step 4:

We get headers in 2nd Page also etc..

 

 

 

 

Print
Tags:
Rate this article:
No rating

SurendraSurendra

Other posts by Surendra

Please login or register to post comments.