In SSRS, we use this property of the tablix to repeat column heading in each page of the report.
But some times heading are not repeatable even after this check box is selected because of row grouping being used in the report. To handle this situation we make some changes in advance properties of the tablix like this:
Select the table for which the heading have to be repeated and check the Advance mode option as seen below:
Select the static from row group which is normally used for heading and set the two properties as highlighted in the image below:
Please note that there are two static tab before row grouping tab in our example due to the extra line below table heading. So we need to change the properties of both of the static tab in a scenario like this.
Now deploy the report and the header will repeat on each page even with the row grouping existed in the report.
But some times heading are not repeatable even after this check box is selected because of row grouping being used in the report. To handle this situation we make some changes in advance properties of the tablix like this:
Select the table for which the heading have to be repeated and check the Advance mode option as seen below:
Select the static from row group which is normally used for heading and set the two properties as highlighted in the image below:
Please note that there are two static tab before row grouping tab in our example due to the extra line below table heading. So we need to change the properties of both of the static tab in a scenario like this.
Now deploy the report and the header will repeat on each page even with the row grouping existed in the report.
No comments:
Post a Comment