Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 10, 2012 09:40 AM by Nishantg
Participant
778 Points
955 Posts
Feb 09, 2012 12:23 PM|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.
1254 Points
277 Posts
Feb 10, 2012 09:40 AM|LINK
Hi,
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.
mou_inn
Participant
778 Points
955 Posts
Want to show fix number of rows per page in SSRS
Feb 09, 2012 12:23 PM|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.
</div>Nishantg
Participant
1254 Points
277 Posts
Re: Want to show fix number of rows per page in SSRS
Feb 10, 2012 09:40 AM|LINK
Hi,
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.
Thanks
Nishant