Want to show fix number of rows per page in SSRS RSS

• • Reply
  

  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

  <div class="post-text" itemprop="description">

  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>
  • Edited by mou_inn on Feb 09, 2012 12:24 PM
• • Reply
  

  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.

  Please mark as Answer, if its help you.
  Thanks
  Nishant
  • Marked as answer by mou_inn on Feb 13, 2012 05:55 AM