Friday, November 2, 2007

SQL Server Reporting Services number of rows per page

Set a number of rows per page with the grouping trick:

Go to Table Properties - GroupsAdd a Row Group with the following function: =Ceiling(RowNumber(Nothing)/30)Make sure "page break at end" is checkedNow you have a set number of rows and with that a set vertical size(assuming text does not wrap).Make the control a little wider then needed and you should not have scrollbars (most of the time).

Found the code here:
SQL Server reportingsvcs ReportViewer control always shows scrollbars