Search This Blog

Fixing Table Header,Tablix Header, Image or TextBox While Navigating From one Page to Another or while Scrolling Down In SSRS Report

Fixing Table or Tablix Header, Image or TextBox In SSRS Report

When there are lots of Record in the Report and you want that Table Header i.e Column Names Should be Fix while Navigating to other Page Same way u want your company logo which is on the top of Report or any other Image or Text Box where you have written the Report Name Should be fixed 

For these type of Scenarios 
1-To fix Table Header or Tablix Header 

Go to Column Group-Right Hand Side below ur Report
Click arrow key


Click on Advanced Mode it will show some fields both in Column Group and Row Group 
These are nothing but No. of Columns and Rows 

Go to Rows Group Not in Column Group

Click on First Static--This is the First Row

Right Hand Side it will Open Tablix Member Properties
Change Following Properties  as Described Below

Fix data- True
Keep with Group-After
Repeat on New Page-True

Now Preview the Report the first Row which is a column Names is fixed 

Another way is Selecting your table
Right Click-Tablix Properties
In General Tab
Row Header
Select -Repeat Header Rows on Each Page

If you want header or ColumnName should be fixed while scrolling the Report when Records No. are more

Select-Keep Header visible while Scrolling

Preview Report 

2-To fix Report Name or Image or Logo any other Item which you want to fix Means like in our case while going to Next page we want Header Image and Report Name should be fixed 

Select your Text Box or Image
Right Hand Side-Properties
In the Other Properties
Repeat with-Select Tablix1--Your Tablix Name

Do it for other Reports items Which you want to Repeat or fixed while Moving from one Page to Another.



Preview the Report-Your ReportName and Image is also fixed along with Column Names when moving from one Page to another.







1 comment:

  1. only fix for Internet explorer not for Chrome...

    ReplyDelete