pass filter value to hyperlinked ssrs report

I have a dashboard with a time intelligence filter and a scorecard. On the scorecard I have a hyperlink to an ssrs report. I want the user to be able to click the link and the SSRs report open up filtered on the vale that the dashboard filter contained. The ssrs report uses the same data source as the filter. How can do this?

Thanks,

Dan

March 3rd, 2013 12:45pm

Here is one solution:

Create a dashboard page with the SSRS report. Reuse all the filters from the Main dashboard page on the SSRS report page. On the scorecard use the hyperlink of SSRS report page. PPS caches and retains values selected on filters across dashboard pages. So when you change values on Main page they are reflected on Report page. And finally moving to Report page will show the report with all the filters selected.

Hope it helps.

Free Windows Admin Tool Kit Click here and download it now
March 6th, 2013 7:30pm

Thanks!

March 9th, 2013 11:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics