Passing parameter via url to sql server reporting service

Question

I'm trying to pass a parameter via the url to SSRS and it appears not to work!

I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query.

base url: http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport

tried this but it doesn't work: http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport&UserId=fred

Any ideas

Answer 1

Try changing "Reports" to "ReportServer" in your url

Answer 2

As well as what Shiraz said try something like this

http://<server>/ReportServer/Pages/ReportViewer.aspx?%2f<path>%2f<ReportName>&rs:Command=Render&UserID='fred'

Note the path would only work if you are in a single folder. When I have to do this I simply browse to the report using the reportserver path ("reports" is the report manager) and copy the url then add &<ParamerterName>=<value> to the end.

Answer 3

I've just solved this problem myself. I found the solution on MSDN: http://msdn.microsoft.com/en-us/library/ms155391.aspx.

The format basically is http: //<server>/reportserver?/<path>/<report>&rs:Command=Render&<parameter>=<value>

Answer 4

Hi I am trying to pass multiple values via url like

/ReportServer?%2fService+Specific+Reports%2fFilings%2fDrillDown%2f&StartDate=01/01/2010&EndDate=01/05/2010&statuses=1,2&rs%3AFormat=PDF

I get the following error Default value or value provided for the report parameter 'statuses' is not a valid value. (rsInvalidReportParameter)

Same url works fine if I just pass 1 parameter to 'statuses'

Thanks

Answer 5

Thanks Shiraz for your quick response.

But I cannot change "service specific Reports" to "Service Specific ReportServer" because it "Service sepcific reports" is the location of my report "Drilldown"

any other suggestions?