Showing posts with label drill. Show all posts
Showing posts with label drill. Show all posts

Monday, March 26, 2012

Parameter Input Area on Drill Through

Does anyone know a way to force RS to not collapse the parameter area on a drill through? I searched this forum and found some related threads but nothing that covered this.

I have several reports where they drill through to each other and in all cases, while they pass the parameters between, the users usually want to go directly to different products or time periods within the reports. They constantly have to expand the input area every time they go to another report. This confuses a lot of them.

Is there a setting somewhere that controls this?

Thanks, Tim

Sorry, this can't be changed in Report Manager or Report Server URL Access. If you were to use the VS Reporting controls in a custom app, you'd be able to do this.

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...