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