Want to show fix number of rows per page in SSRS

Question

i search google for showing fix number of rows per page in SSRS and found solution like 1) add group and put a expression like for the view =CEILING(RowNumber(Nothing)/10).

from this website http://gauravsqlserver.blogspot.in/2011/03/how-to-fix-number-of-rows-per-page-in.html i got the info and follow all the step but when i compile report then i am getting error like

A sort expression for the tablix ‘Tablix5’ uses the function RowNumber. RowNumber cannot be used in sort expressions.

so please guide me how to fix this error and also tell me am i on right track to show 10 records per page.

Answer 1

In the group properties, go to Sorting.

You may find a default sorting created.

Delete it and try to run the report.