Post reply

Fixing number of rows per page

  • July 7, 2016 at 12:04 am

    #308850

    Hi experts,

    How can I fix the number of rows in tablix to display consistently in each page? I have tried using =iif(ceiling(rownumber(nothing)/10),True,False) this method, but since I have group inside the tablix and having subtotal per item and grand total by all. How can I do that? For example, I just want to display only 10 rows no matter what. Is there anyway I can work it out only in report level?

    :pinch:

  • July 7, 2016 at 12:12 am

    #1888844

    your rows per page expression is good enough.

    check if this works: put the subtotal before the rows per page expression and put the grand total after the rows per page expression.

  • July 7, 2016 at 1:04 am

    #1888849

    Hi durga.palepu

    Which part am doing wrong? I am having error.???

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply