Wednesday, March 21, 2012

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take one parameters in the URL to generate a detail report. when i pass parameter as

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=123

it works fine . But i want to send master report's parameter to detail at run time which is selected in master report, then i got an error

i want to use

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" &Parameters!p1.Value& "

but an error come i,e

" The path of the item '/UpdatedByClickTest/S,Parameters!p1.Value, "' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath)"

how can i pass parameter to remove this error?

plz any one help me i shall be thankfull to you

Hello Arshad,

Where are you trying to generate the URL?

If you just want to display a link, this will append your parajmeter to the URL:

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" + cStr(Parameters!p1.Value)

Hope this helps.

Jarret

|||

Thanks Jarret its working now i m using

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" & Parameters!p1.Value

now i want to use global server name becuase i will have to deploy reports to different servers e,g DEV, QA and Production

i m using code like

=Globals!ReportServerUrl & "?/UpdatedByClickTest/S&rs:Command=Render&P1="&Parameters!p1.Value

but its not working plz send me ur code.

|||

That should work, but not while you are designing the report. I tried what you posted and it worked when I deployed the report. When you deploy it to the server and run it from there, you should see the ReportServerURL showing correctly.

Jarret

No comments:

Post a Comment