Monday, March 12, 2012

parameters not showing up in report manager

Hi,
My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
action of a textbox. REPORT1 has one parameter.
Every thing works fine except I would like to be able to change REPORT1
parameter after I execute it, but it does not display when in Report
Manager.
ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
REPORT1 displays fine. While in REPORT1, I would like to change
parameter1="ZZZ".
I am unable to do this in the Report Manager because it will not show up in
the parameter header of Report Manager when I jump from MAIN to REPORT1.
It will show up if I execute REPORT1 by itself.
How can I get REPORT1 parameter1 to display after I jump to it from the MAIN
report using the report manager?
I have checked "prompt user" of REPORT1 setup in Report Manager.
Thanks,
___________________________
Daniel J. Zaccarine
Hanford Bay Associates, Ltd.
___________________________You need to use jump to URL instead. (at least that is the only way I found
to do it). Note that you can use some of the global variables with the
expression builder to create this on the fly (so it changes with wherever it
is deployed.
http://servername/Reports/Pages/Report.aspx?ServerUrl=http://servername/ReportServer%3f/directoryname%252fReportName&Parameter1=blahblah&rc:Parameters=True
Bruce L-C
"Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
news:uMzOo%23obEHA.2476@.TK2MSFTNGP09.phx.gbl...
> Hi,
> My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
> action of a textbox. REPORT1 has one parameter.
> Every thing works fine except I would like to be able to change REPORT1
> parameter after I execute it, but it does not display when in Report
> Manager.
> ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
> REPORT1 displays fine. While in REPORT1, I would like to change
> parameter1="ZZZ".
> I am unable to do this in the Report Manager because it will not show up
in
> the parameter header of Report Manager when I jump from MAIN to REPORT1.
> It will show up if I execute REPORT1 by itself.
> How can I get REPORT1 parameter1 to display after I jump to it from the
MAIN
> report using the report manager?
> I have checked "prompt user" of REPORT1 setup in Report Manager.
> Thanks,
> ___________________________
> Daniel J. Zaccarine
> Hanford Bay Associates, Ltd.
> ___________________________
>

No comments:

Post a Comment