SSRS header to be frozen while scrolling down the report

0
votes

enter image description hereI am trying to keep header rows static while scrolling through the report in SSRS, Visual Studio 2012.

I have tried the following and it has not worked : Under Design Pane - > Row Groups - > click on (static) - > Press F4 - > Properties window will pop up.

In the Properties window - >Set KeepWithGroup = After and RepeatOnNewPage = True.

If you want the header to be frozen while scrolling down the report, set FixedData = True.enter image description here

1
visual-studio-2012reporting-services

1 Answers

1
votes

If you want the header visible while scrolling, you need to go to (right click on tablix) Tablix Properties > General and check the option Keep header visible while scrolling. Then go to column/row groups in the advanced mode, chose your static row and set the Fixed Data mode to True, Repeat on new page to True and Keep with group to After.

Here is prbably the best reference: KeepHeaderVisible