Performance Point SSRS Reports

The other day a client needed a utilize the same SSRS Report in 4 places on the same Performance Point Dashboard, pretty simple right, yup create 4 PPS SSRS reports with the correct default parameters and drop them on a dashboard. Well it turns out that when the reports refresh themselves the default parameters do not get reused and the parameter used for reports gets carried forward from the report that was previously refresh, Arg!

So the solution was to create a SharePoint page with four report viewer web parts. One thing to note is that every time you edit a reportviewer web part the tool bar options all get re checked, even if you have painstaking unchecked them previously.

Advertisements