Pass SSRS report paramter through URL

Issue:

Parameter values passed through URL does not affect the opened report.

What?

Pass parameters from one report in a web part to another in a new page retaining the selected filter values from the web part.

How?

=”http://SharePointSite/ReportServer/Pages/ReportViewer.aspx?http%3a%2f%2fSharePointSite%2fShared+Documents%2fDrillthrough_test_hyperlink.rdl&rs:Command=Render” &

“&Matter_Name=” & Join(Parameters!Matter_Name.Value, “&Matter_Name=”) &

“&Week_Day=” & Join(Parameters!Week_Day.Value, “&Week_Day=”)

Why?

The trick is in accessing the report server and avoid report manager. I browsed to the report required, in this case Drillthrough_test_hyperlink.rdl and appended the corresponding URL to the expression instead of using the report managers.

http://SharePointSite/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Shared%20Documents/Drillthrough_test.rdl //BAD

http://SharePointSite/ReportServer/Pages/ReportViewer.aspx?http%3a%2f%2fSharePointSite%2fShared+Documents%2fDrillthrough_test_hyperlink.rdl //GOOD

So? Drillthrough to a new report that retains the filtered parameters works as expected using the above expression in the goto URL action of the report. As of now no idea/understanding as to why report manager does not work/pass values.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s