Friday, March 9, 2012

Paging in Drill Down Reports

My requirement is that i want to have paging i.e show 20 records per page in
a Drill Down report.
How to do it or where can i find a solution to this?
Thanks in advance...Hi Piyush. The only thing I can think of is to create a "fake" grouping
column. For every 20 rows, change the group number. Then create a group on
the grouping column and pagebreak at the end of each group. Does this make
sense?
-Tim
"Piyush" <Piyush@.discussions.microsoft.com> wrote in message
news:B3D1BB6D-F1F3-44AC-9EE3-BF3F662E92F5@.microsoft.com...
> My requirement is that i want to have paging i.e show 20 records per page
> in
> a Drill Down report.
> How to do it or where can i find a solution to this?
> Thanks in advance...|||Giving this expr. in the group will break at 20th row.
=Int((RowNumber(Nothing)-1)/20)
Amarnath
"Piyush" wrote:
> My requirement is that i want to have paging i.e show 20 records per page in
> a Drill Down report.
> How to do it or where can i find a solution to this?
> Thanks in advance...

No comments:

Post a Comment