Be sure to leave the group header & footer boxes unchecked. In the Group By expression, enter =CEILING(RowNumber(Nothing)/50) where 50 is the number of records to be displayed per page. The following discussion presumes that the report has been developed & all that's left is handling the pagination.įirst, add a Row Group which is a Parent of the existing top level group. The solution we opted to use was to limit the report records displayed to 50 rows per page, which involves using the Ceiling function in SQL Server Reporting Services. When the interactive size property did not have any effect at all, which is still a mystery to me, we decided on a different approach. Recently we had a requirement to reduce the height of an SSRS report which was being rendered in SharePoint’s Report Viewer.
0 Comments
Leave a Reply. |