This is a very basic requirement where one would like to check their data along with the Column Header even while scrolling i.e. making their Column Header page static.
Even after you check the “Keep Header Visible While Scrolling” option in the Tablix properties of the Header Row, it won’t work at all !!!
This would needs some extra settings:
1> First UnCheck the “Keep Header Visible While Scrolling” option in the Tablix properties of the Header Row.
2> At the Footer move to Row/Column Group and click on the Advanced Mode Option.
3> After clicking on the Advanced Mode, all the static property displays for Rows and Columns respectively.
4> Now Click on the First static property of the Row Group which denotes the Header and open the properties section. In my case I had 3 headers so had to click all of them one by one. Set the ‘FixedData’ value to ‘True’.
Once done, check the preview of the report. The Column Headers becomes Static now even while scrolling the page.