Setting specific row numbers for report pages

Ekin
Ekin Member Posts: 28
in NAV Three Tier
Hello,

I need to create a report, this report must have 10 rows for first page, rest of the pages must contain max. 25 row per page. Is it possible to create a condition like this? I've done 20 rows per page using Integer DataItem before, but I couldn't be able to create this condition using Integer DataItem.

I have tried the solution in this link: http://stackoverflow.com/questions/10467997/how-to-page-break-after-specific-rowsuppose-25-rows-in-rdlc-reporting

In the Groups' expression I've given this condition;

Iif(Fields!CurrReport_PAGENO.Value>1,System.Math.Ceiling(RowNumber(Nothing)-1/25)+1,System.Math.Ceiling(RowNumber(Nothing)-1/10)+1)

It doesn't solved my problem.

Any suggestions?

Ekin

Best Answer

Answers

  • Ekin
    Ekin Member Posts: 28
    edited 2016-10-11
    Kishorm wrote: »
    Try something like this (you may need to tweak the numbers slightly, and please be careful about brackets - you are missing some in your original expression)...
    IIF(RowNumber(Nothing)>11,System.Math.Ceiling((RowNumber(Nothing)-1+15)/25)+1,1)

    Hello Kishorm,

    I've updated the code as : =IIF(RowNumber(Nothing)>11,25,10) and it worked perfectly fine.

    Thank you, it was very helpful.

    Ekin

Categories