Add parameter to report URL: Parameter is missing a value

Question

I'm trying to insert an SSRS report in a webpart in SharePoint. The report is a TFS Sprint Burndown chart. For this, I need to generate the report using the following URL:

http://vhacpadev04/ReportServer/Pages/ReportViewer.aspx?/TfsReports/VAPARS+Team/Sprint+Burndown&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=true&rp:SprintParam=Release+2%5CSprint+1

The project name in TFS is VAPARS Team. The sprint I'm trying to run this chart for is Release 2 Sprint 1.

Typically, the ReportViewer will prompt me for this parameter. In this case, SprintParam:

However, when I hide this (using &rc:Parameters=false), then I get the following error:

And here's the parameter properties for this report on SSRS:

I'm not sure how to format the URL to pass the correct sprint parameter. Any suggestions?

Answer 1

You need to provide a default value for SprintParam (even though you are overriding that in the URL) or you need to remove the dependency on the parameter if it is used for cascading parameters. The report thinks it cannot run without this information, even though you are supplying it in the URL. StartDateParam and EndDateParam are query based so I'm guessing those have a dependency on the SprintParam. That's what is causing the error to display and your URL parameters are ignored.