Quarry


Hi, I've read some threads in regards to passing report parameters through the 'URL' but I am struggling to fully understand. To keep things simple I have 1 report parameter, named par_pub which brings back either ww06 or ww07. What I require is to click on a hyperlink and it directs me to my report and then populates the par_pub paramerter with ww07.

I am trying the below

http://emp6/Reports/Pages/Report.aspx ItemPath=%2fTest+Reports%2fIT+Dev%2fSales+Summary+Detail&prefixStick out tonguear_pub=%WW07%

The part in bold is the location + name of the report and the later is where I am trying to pass the parameter. Can anyone please help as this is not working.

Thanks




Re: Passing Report Parameters through URL

Priyank Pandey


Quarry,

I tried using parameter in reportserver (instead of manager) and they worked fine.

reportserver can be launched as http://server_name/reportserver.

No idea why they are not working with report manager.






Re: Passing Report Parameters through URL

ronicard

Quarry,

I've gotten my reports to work with passing parameters through the URL; with the exception of date fields. They have been giving me fits. To answer your question though, try this:

Try opening a browser and start off just typing the name of your report server's URL. For instance: http://machinename/reportServicesInstancename.

That will open up the list of folders where your reports are located. Click on the folders and files until you have selected and opened your report. Then go into the address box and copy that value. Paste that into your code as the string you want to deal with and appendan "&par_pub=WWW07" to it (I'm not sure why you have %'s around the WWW07 there, unless it's something your app needs.

Ron






Re: Passing Report Parameters through URL

Quarry

Hi Ron, I've tried this but my URL link opens up the report in Report Manager but does not poplulate the parameter value.





Re: Passing Report Parameters through URL

Raj Deep

Irrespective of URL,when you select the parameter manually, like "www07".does the URL get changed If not there is no point we can pass parameter through URL

if this is true, the other way we are speaking should be true.

Guys,please correct me if i am not correct.

I dont have Enough knowledge on passing parameters through URL,if you have done any work around before like this.defly i am interested share to knowledge.

Once again,please correct me if i am wrong.I am not sure






Re: Passing Report Parameters through URL

Quarry

I have tried this manually as you suggested, and the URL does not change when I select a parameter value. Does this mean that I cannot pass the value of the parameter from within my URL link to my report in Report Manger



Re: Passing Report Parameters through URL

ronicard

It's not going to change when you select it manually. The reason I was telling you to open it up manually is to make sure that you have the first part of the string working correctly. Once you have the report opened, select the entire path and all querystring parameters that are included along with it there in the address bar. I would then suggest you open up a new browser window and try pasting that into the browser window and make sure that when you select it, it will run (without the parameter being set yet). If it does work, then go into the address bar in the very same window and add in the "&parametername=parameterValue" statement and try running it again from the command line.

In other words, get your report running (using your parameter) from the command line first. Once you do that, THEN go paste that line of code into your code and get it running via code. I just find this approach more easier than trying to debug from within code when I have SSRS syntax errors.





Re: Passing Report Parameters through URL

Tom Hosu

How did you solve the problem

I have the same issue

Thanks