Showing posts with label generate. Show all posts
Showing posts with label generate. Show all posts

Monday, March 26, 2012

parameter entry / view report

I'm fairly new to RS, but have created some reports and deployed them.
I have parameter value list that is generate from a SELECT statement.
To be a bit more user-friendly, I'd like the user to be able to click on an
entry in the parameter list and have the sytem run the report without having
to click the View Report .
Is there a way to avoid having the user click the View Report ? It would
save a step and is something that can become annoying as the user moves from
one report to another based on the parameter chosen.
TIA,
DougIf you use the enter key the View Report button is the default. I do this
instead of clicking on it sometime.
RS does not know when you are on the last parameter, you need to either
click on view report or use the enter key.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doug" <Doug@.discussions.microsoft.com> wrote in message
news:5F6FC4F0-F033-4B3D-9565-DE61F0FD0E34@.microsoft.com...
> I'm fairly new to RS, but have created some reports and deployed them.
> I have parameter value list that is generate from a SELECT statement.
> To be a bit more user-friendly, I'd like the user to be able to click on
> an
> entry in the parameter list and have the sytem run the report without
> having
> to click the View Report .
> Is there a way to avoid having the user click the View Report ? It would
> save a step and is something that can become annoying as the user moves
> from
> one report to another based on the parameter chosen.
> TIA,
> Doug

Monday, February 20, 2012

Page numbering - X of Y format

I have a reporting services application which generate reports for given IDs. You can pass any number of IDs.
e.g.. If you pass 2 IDs it will generate a single report for those 2 IDs..
Page numbering would look like
1,2,3,1
for ID 1 it has generated 3 pages while for ID 2 it has genereted only 1 page.

But I want the page numbering to return 1 of 3,2 of 3, 3 of 3, 1 of 2, 2 of 2.

Parameters i pass to generate the report is only the ID. It will be in a string format & the SP I use to get data split the string & get the relevant IDs...

Any help to achieve this will be great.

thanks

If you don't need the "of y Pages"-Part look at:
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
|||Hi thanks for the reply; but i doo want of y pages :(

Page numbering - X of Y format

I have a reporting services application which generate reports for given IDs. You can pass any number of IDs.
e.g.. If you pass 2 IDs it will generate a single report for those 2 IDs..
Page numbering would look like
1,2,3,1
for ID 1 it has generated 3 pages while for ID 2 it has genereted only 1 page.

But I want the page numbering to return 1 of 3,2 of 3, 3 of 3, 1 of 2, 2 of 2.

Parameters i pass to generate the report is only the ID. It will be in a string format & the SP I use to get data split the string & get the relevant IDs...

Any help to achieve this will be great.

thanks

If you don't need the "of y Pages"-Part look at:
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
|||Hi thanks for the reply; but i doo want of y pages :(