Monday, February 20, 2012

Need to Understand how to Do Simple Pagination

I'm running Reporting Services 2005 and I need a report that basically
shows only 10 lines per page. I'm trying to google around for answers
on this, but they are not straight forward at all!On Feb 21, 11:33 am, "Daedius" <richard.An...@.gmail.com> wrote:
> I'm running Reporting Services 2005 and I need a report that basically
> shows only 10 lines per page. I'm trying to google around for answers
> on this, but they are not straight forward at all!
I know that if you were using columns in your report, you could group
on expression: =Ceiling(RowNumber(Nothing)/10) where 10 is the number
of lines/rows before starting a new column. I would guess that this
could also be used w/report objects as well (i.e., tables, lists,
etc). Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||You can use something like this. in a page break from group,
=Int((RowNumber(Nothing)-1)/25) 25 is the line to display, in your case it
should be 10..
Amarnath
"Daedius" wrote:
> I'm running Reporting Services 2005 and I need a report that basically
> shows only 10 lines per page. I'm trying to google around for answers
> on this, but they are not straight forward at all!
>

No comments:

Post a Comment