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

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