In one of the projects I had to create reports (using Reporting Services) that then should be accessible from the application I’ve been developing.
As the first thing I created the reports themselves (RDL files), deployed them using the Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress), and configured so I could access them. However, each time I accessed a report I had to provide the input parameters which were used by the stored procedure in order to deliver appropriate amount of information. I wanted to avoid that by passing the parameters somwhowin the URL.
Google came with two interesting articles: Using SQL reporting services in an asp.net application with some notes on report parameters, and Passing parameters and other options directly through a URL in Reporting Services. I followed the instructions but failed. In fact I got stuck making minor changes to the URL, checking the configuration, googling further…
It was only my friend who spotted that I tried to pass the parameters to the Report Manager using URL similar to http://localhost/Reports/Pages/Report.aspx?ItemPath=XXX&rs:Command=Render&ParamName=ParamValue. Instead I should use the Report Server, so link looking this way: http://localhost/ReportServer/?XXX&rc:parameters=false&rs:Command=Render&ParamName=ParamValue.
Note: Please remember there are two services: Report Manager and Report Server and understand the difference between them. This way you won’t loose presous time, as I did 
Thanks for pointing this out – I’ve been unsuccessfully trying to pass parameters and hadn’t noticed this. :-S
Thanks So much, I was in the middle of frustration whan I found this,
Thanks so much….i tried with this link and it finally work:
http://rs/ReportServer/Pages/ReportViewer.aspx?%2fFolderName%2ReportName&rs%3aCommand=Render&ParamName=ParamValue
Thanks
thanks for pointing out the difference
You are a lifesaver! Thanks for posting this information! I was about to lose my mind…
Thanks a lot trying to sort this out for 3 days
Thank you very much,
Very usefull. We saved a lot of time thx to your comment.
Grt,
unfortunately I still have a prob.
I use =”javascript:void(window.open(‘http://vmsql03/ReportServer/RequestDetail1?%2fVMSQL03%2fRequestDetail1&rc:parameters=false&rs:Command=Render&RequestID=(Fields!RequestID.Value’))”
my second report doesn’t acknowledge the value from 1st report when I click it.
if I run manually yes…it works fine.
any idea?
Thanks,
Thank you. It’s very helpful for me.
Thank you! Exactly what I needed.
THANK YOU!! This finally solved my problem!
Saved me a lot a time and hassle! Thanks, exactly the information I was looking for.
My report runs in report manager but not in report server, it gives an “internal error”. Please help.
You made my day man. Many thanks!
Wow, thank you so much! I was going nuts trying to figure this out. Jeez, so simple.
Please go through given below link>>
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5c525e46-c47e-4bea-9356-ac93537cb88c
I have the following code to pass the parameters to my second report. from my main report when I click on a cell examp. week 17 then it open a seperate window but not actives the second report in that window. Parameters below are not being passed. How can I do it?
=”javascript:void(window.open(‘http://srvrreport10/Reports/Pages/Report.aspx?ItemPath=%2fTEST+-+Reports+-+BETA%2fSecond_Revision__Issues-Sub&rs:Command=Render&DimDateYear=”+Parameters!DimDateYear.Value+”&MasterAreaText=”+Parameters!MasterAreaText.Value+”&DimDateWeek=[Dim Date].[Week].["+Fields!Week.Value+"] ‘))”
http://taposh.wordpress.com/2008/09/26/passing-parameters-in-url-to-view-a-ssrs-report/
Thanks so much for this post. Very helpful indeed!
Genius, this is awesome information.
Still helping people save time. Thanks!
Thanks for this tip.
)
It is good to know. I was searching 5 hours to get the answer how to pass parameter to the report. And of course I tried with Report Manager and not the Report Server.
Your tipp was very good.
Thanks for posted it.
Have a nice day:
Ildiko
I have a same problem as Susan, listed above, this is the expression i am using:
=”javascript:void(window.open(‘http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID=”+Fields!ProjectUID.Value+”‘))”
and for some odd reason its not working.
its not giving me any error, instead no hyperlink on the text box is available to click. if i hardcode the parameter value in the same expresson, it works.
would much appriciate if you or anyone of your reader can help me in this.
Awesome!..i was stuck with the issu since like two days. Didnt think the reason could be so trivial yet so important. Thanks.
Thank you. This was extremely heplful !
how am i to pass the parameter to cube.
url i tried:
http://localhost/ReportServer?%2fReport%2ftest&rs:Command=Render&rc:toolbar=false&rc:Parameters=false&TimeYear=Time.Year.&‘[2011]‘
[Time].[Year].[All] works but the other values doesnt:(:(.
Please help to fix
Thank you so much for posting this information (I knew of the facts from a while ago, but had forgotten the sytax and concept presently during all my SSIS work). I had to do a quick website with pulling the report names and url links from a Report enry table I created. Your posting cleeared up my URL sytntax.
Thank you Sincerely, Chris Beckwith
Thank you!
You helped me also, I add parametr “zestaw”
http://cz1xx-tst/ReportServer/Pages/ReportViewer.aspx?%2fRaporty%2fR0256&rs:Command=Render&zestaw=624033900A
I have a report and am passing parameter values in URL and able to get the result successfully in development environement but in production am not.
This is because on the Prod environment when we go into any report it asks for user credentials (At this step the link parameters get lost).
Any inputs?
Thanks in advance.
Hi,
What if the required parameter to be passed is a multi valued parameter ie ParamName has two values ParamValue1 and ParamValue2.could you help me with the syntax.
Thank you.
Thanks a lot. Helped me partially.