SQL Server Performance

Limit the number of rows on a page in a Matrix

Discussion in 'SQL Server Reporting Services' started by vinnie881, Aug 30, 2006.

  1. vinnie881 New Member

    This question has been stumping me for hours. I have a report with a matrix, and I only want to display 10 records per page. I can do this fairly easy if it was a table using

    =Ceiling(Rownumber(nothing)/10

    under the table group settings, but in a matrix the rows are grouped, and this does not seem to work.

    Any help would be greatly appriciated.

    Regards,

    Vinnie

Share This Page