Last post Feb 10, 2012 05:40 AM by Nishantg
Feb 09, 2012 08:23 AM|mou_inn|LINK
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.
Feb 10, 2012 05:40 AM|Nishantg|LINK
Go to your Group properties and then select Sort expression and delete the expression, your error should get resolved.
Basically, this is very weired situation, when you create a group based on expression, its by default take the same expression as Sort Expression.
So you just need to delete the Sort expression.