Setting specific row numbers for report pages

Ekin

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

Kishorm

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)

Kishorm

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)

Ekin

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