Groups | Blog | Home
all groups > sql server reporting services > february 2007 >

sql server reporting services : Need to Understand how to Do Simple Pagination



Daedius
2/21/2007 9:33:14 AM
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!
EMartinez
2/21/2007 8:25:11 PM
[quoted text, click to view]

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
Amarnath
2/21/2007 8:30:15 PM
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


[quoted text, click to view]
AddThis Social Bookmark Button