Tuesday, 28 January 2014

SSRS: How to set number of Rows per page

Scenario:
I have 400 records in my report , i  want display 20 records per page , how can i do the same in ssrs.

Solution:

You need to do this at the group level. If you do not have group, then add one but uncheck the 'Include Group Header' and 'Include Group Footer'. But when ask to Group by what, use: =Ceiling(RowNumber(Nothing)/20)

This will break it every 20 rows.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home