This blog is moved to
http://amalhashim.wordpress.com

Friday, October 9, 2009

SSRS - Creating reports with specific rows per page

In layout tab, select the table and open the properties windows by right clicking and selecting properties. From the properties windows move to the Groups tab. Click Add and enter the following expression

=Ceiling(RowNumber(Nothing)/20)

Replace 20 with the required number of rows per page. Select "Page Break at Start" and uncheck "Page break at Start". If you want the header and footer to be appear on each page then select those options.

Hope this helps :-)

No comments: