Hello Everyone, I'm totally and completely confused as to how to pass multiple paramters through a URL. Book Online is absolutely no help because they do not offer any examples of passing multiple paramters within a URL. Instead, I get confused over RENDER and COMMAND and what should be repeated where with each paramter and on and on and on. Here's my URL: javascript:void(window.open('http://sereporting01.wdig.com/ReportServer?%2fDOL%2fTEST%2fDisney+Sell-Through&rs:Command=Render&SiteName=Disney,InsertionType=300 x 250,Context=ROS','_blank','resizable=yes,toolbar=0,menubar=0')) What happens is that JavaScript opens a new window but I get a "Reporting Services Error". I'm assuming it's because my URL parameters are not correct. Can someone please just give me the correct syntax so that I can get on with my work? I'm editing this post to add - I'm also confused as to how paramters are supposed to be passed through to a report when default paramters are set up in the report which i'm trying to open with the URL. Should I remove the default paramaters from the report or...what? Again, BOL offers no help on this issue and it just seems to generate more questions. Thanks!!

For some reason I can't seem to edit my original post so i'm posting a reply here. I'm also confused as what to do with DEFAULT parameters in the report which i'm trying to connect to. Should I take the default paramters out of the report which i'm trying to connect to? Again, BOL offers no guidance on this at all. Additionally, i'm trying to use a SWITCH in the URL expression because the URL string will have different parameters depending on what metrics i'm trying to pull. In other words, i've got something which looks like this: =SWITCH (Parameters!Site_Name.value = "Disney", <URL FROM ABOVE>, Paramters!Site_Name.value = "Disney XD", <URL FROM ABOVE>)

Hi, To pass multiple parameters through URL, we can use an ampersand (&) to separate them. For example, I have a report with two parameters p1 and p2. The report is deployed in a folder on the Report Server. When I navigate to the report on the Report Server, I can see the report URL is http://localhost/ReportServer_SQL2008NEW/Pages/ReportViewer.aspx?%2fFolder%2fReport&rs:Command=Render. If I need to pass parameters through URL, I can just add &p1=value1&p2=value2 at the end of the URL and the entire URL would be http://localhost/ReportServer_SQL2008NEW/Pages/ReportViewer.aspx?%2fFolder%2fReport&rs:Command=Render&p1=value1&p2=value2 So, based on the URL you posted, you can correct it like: http://sereporting01.wdig.com/ReportServer/Pages/ReportViewer.aspx?%2fDOL%2fTEST%2fDisney+Sell-Through&SiteName=Disney&InsertionType=300 x 250&Context=ROS As you mentioned the parameter rs:Command=Render, this kind of parameters which with prefix are used to configure the appearance of the report rendering by Report Server. If there is no special requirement, we can omit them because they are optional. For the parameters with default values in your report, if we also pass parameters through URL, the report will use parameters in the URL rather than the default values. Using SWITCH in URL is not available because URL is just a location of web pages. To navigate to different reports by parameters, please refer to http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/de5d3eae-5863-4f72-a5e8-dab837b8aa84 If you have any question, please feel free to ask. Thanks, Tony Chain

Hi , I looked at all the possible places on earth to see a solution to my simplest quest! I want to access the parameter passed to the report. I understand that we can pass the parameter by &p1=value1&p2=value2 but I do not know how do I access this parameter in my report, to which I had passed this parameter. Let me know if I did not frame the question correctly. I want an equivalent of Request.QueryString("p1") in report. Regards, MP