Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : Way to reset parameters after 'View Report' button is hit


postet NO[at]SPAM gmail.com
8/11/2005 10:36:25 AM
Looking for a way to reset a parameter when the 'View Report' button is
pressed. As it works out of the box, when you change a parameter and
hit 'View Report', the parameter retains that value after the report is
generated. What I need is for the parameter to reset to default after
the report is generated.

Example:
1)ParameterX has default value of 0.
2)User changes ParameterX to 400, and hits View Report.
3)Report is generated, and ParameterX still shows 400 above in the
Parameters area.

This is all well and good, however, I would like that 400 to reset to
the default of 0 at step 3 above. To be clear, I still want the report
to be run with the 400 , I just don't want the 400 to still be there
above in the parameters area when it is finished.

Any ideas/tricks before I start hacking away?

Thanks!
Bruce L-C [MVP]
8/11/2005 1:24:59 PM
Only way you can do this is to use your own web application. There is no way
to control the behavior of Report Manager.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button