SSRS 2008R2-Tablix report header not repeating

Error: Tablix report header not repeating

Solution: Follow the below steps to show report header in the tablix reports.

1. Go to the Column Groups and right click the triangle ->Then check the Advanced Mode.

2. Next Come to the Row Groups and Click F4 to see the properties.

3. Set the following properties in the tablix member as per the highlighted green colour box.

·         Fixed data to ‘True’
·         Keep with Group to 'After'
·         Repeat on New Page to 'True'

5. Then Save the report and Preview.

As expected, the report features like Repeat headers on Each Page and header visible while scrolling is working fine!


Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)