SSRS 2008 Rpt Bldr 3: Go to URL action not setting parameters
I have a report which has a Go To URL link where I build a custom URL to open with selected parameters embedded. This SHOULD open the report and set the parameters so that the report runs, but it does not. Instead I get "Parameter is missing a value" error because the URL does not set the parameter values.
Here is my URL expression in the main report: ="javascript:void(window.open('"&Globals!ReportServerUrl.Replace("/ReportServer","")&"/Reports/Pages/Report.aspx?ItemPath=%2fRptFolder%2fsubrptMiscPHDetails&rs:Command=Render¶m1="&Parameters!param1.Value.ToString()& "¶m2="&Parameters!param2.Value.ToString()&"'))"
That generates this URL wh开发者_JAVA百科ich DOES open the report properly:
http://<server>/Reports/Pages/Report.aspx?ItemPath=/RptFolder/subrptMiscPHDetails&rs:Command=Render¶m1=2011¶m2=1
However, the parameters do not set set in the report itself as expected. I have checked the names of the parameters and they match exactly.
Anyone see what could be missing?
Thank you!
The answer is I need to use the Reportserver not the manager, so this URL is the one that works:
http://<server>/ReportServer?/Editorial/subrptMiscPHDetails&rs:Command=Render¶m1=2011¶m2=1
精彩评论