CODEWITHSUNDEEP
reporting-servicesssrs-2008
nowYouSeeMe
nowYouSeeMe

Reputation: 1009

SSRS Pass Parameter via URL

I have the following report URL:

/Reports/Pages/Report.aspx?ItemPath=%2fcMIS%2fgradebookProfileView

I'm trying to pass the parameter TG via the URL so it looks like so:

/Reports/Pages/Report.aspx?ItemPath=%2fcMIS%2fgradebookProfileView&TG=10BEE%20C

However this doesn't work, how can I make this work so that it automatically enters 10BEE C into the parameter textbox.

Upvotes: 3

Views: 15155

Answers (1)

Steven V
Steven V

Reputation: 16595

You can't use the /Reports/ front end to pass parameters, you have to use the web services end point to pass the parameter (normally at /ReportServer/). It should still present the Report Viewer interface just like it does on the Reports url.

But your URL would become:

/ReportServer/Pages/ReportViewer.aspx?%2fcMIS%2fgradebookProfileView&rs:Command=Render&TG=10BEE+C

Two things of note. The URL parameter name must match the report parameter name, not the prompt. Also, spaces are encoded to + instead of %20.

Upvotes: 8

Related Questions