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.
only fix for Internet explorer not for Chrome...
ReplyDelete