Sunday, December 21, 2014

SSRS - Display fixed number of rows per page with report headers.

For one of our KPI report hosted on SharePoint, the users want to have fixed headers when they use horizontal scroll. We tried to use the OOTB features(Fixed data=True) but it does not work out properly for us. Hence decided to have fixed number of rows per page and show the headers in each page.

It was decided to have 10 rows per page. I followed what is given in this blog. The downside of it , the headers were visible only in the first page and the subsequent pages did not show the headers. So found a work around which is to add group header while performing step 1 of that blog.

I copied and pasted the report header as the group header and deleted the report header. Then followed the subsequent steps as given in the blog. Now all the pages had headers with fixed number of rows.

Hope this helps you!!!

No comments:

Post a Comment