all groups > sql server reporting services > december 2006 >
You're in the

sql server reporting services

group:

capturing reportviewer parameters


capturing reportviewer parameters Passx
12/29/2006 2:41:43 PM
sql server reporting services:
Hi Guys

I have an application which consists of a navigation bar and a frame.
When a user selects a hyperlink on the navigation bar that particular
report is displayed in the frame. Now these reports contains links
through which the user can jump to some other report which is not
present in the navigation bar. Now when the user clicks any other link
on the navigation bar the new report is starting up using the default
parameters set for that report. But i dont want this to happen. The
report viewer should take the latest parameters set in the report
viewer and pass them to the new report that will be generated when the
user clicks on the navigation bar. Can any body help with this aspect.
it is blowing up my brains. dont even know that whether this is
possible.

Also can we somehow get the url of the report being displayed in the
report viewer." i know that report viewer is an iframe which uses url
access beneath it to access the reports." Only the first report server
url is encoded in the application. But when the user navigated to some
other report through the links in reports how do i get access to that
particular report url .

any help will really be great. I am wondering is it really possible to
do the stuff i just mentioned above. Any tips on this will really save
me a lot of time.

Thanks in advance.../.......
Passxunlimited
Re: capturing reportviewer parameters Jeje
12/30/2006 9:36:57 AM
you have to add some code to save the parameters and reuse them when you
open a new report.

you have to intercept some events (from the reportviewer control) to
retrieve the parameters when the first report is refreshed with new
parameters, save the values into a the session, in the page load event if
you open a new report change the values of the parameters of these reports
regarding what you have saved before.

its not complicated, the API is easy to use to do this.


[quoted text, click to view]
Re: capturing reportviewer parameters Passx
1/4/2007 12:27:55 PM
i was trying to do exactly the same thing . But could not find any
events associated with report viewer wherein i can catch the parameter
values or session state. Any idea or resources regarding this.


thanks
passx

[quoted text, click to view]
Re: capturing reportviewer parameters Jeje
1/4/2007 7:01:34 PM
try the onunload event or any event after the rendering step.

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