Publish Reports to Sharepoint

Publish Reports to Sharepoint

  • Comments 5
  • Likes

As part of SP1 we included the feature to allow reports to be published.  This allows you to take a rendered report with all your parameters selected and publish it for your own and others to use.

This process is detailed in the report authoring guide that was posted earlier.

Following on from where the guide stops , I wanted to share how these published reports can be used outside of the Operations Manager console.

The report now has all its parameters pre-populated so can be run through the http://<servername>/Reportserver URL without the need to render the Operations Manager parameter control. Navigating to and running the report will produce the following:

The URL shown here can now be used to display the report in a webpage or within sharepoint.  All you need to do is copy the URL: (http://<servername>/Reportserver?%2fNewReports%2fThisMonthAvailability&rs:Command=Render) and insert it into your PageViewer or ReportViewer webpart as shown.

This example shows two availability reports one for the previous month and one for this month to allow side by side availability comparison:

You can gain greater control of the display by updating the URL to show/hide parameters and toolbars.

URL Examples:

&rc:Parameters=Collapsed
This collapses the parameter bar but sends the parameters in the URL in the browser.
http://<servername>/Reportserver?%2fNewReports%2fThisMonthAvailability&rs:Command=Render&rc:Parameters=Collapsed

&rc:Parameters=true
This shows the parameter bar and is the default.
http://<servername>/Reportserver?%2fNewReports%2fThisMonthAvailability&rs:Command=Render&rc:Parameters=True

&rc:Parameters=false
This prevents the parameters from being passed in the browser and expanded.
http://<servername>/Reportserver?%2fNewReports%2fThisMonthAvailability&rs:Command=Render&rc:Parameters=false

&rc:toolbar=false
This hides the toolbar.
http://<servername>/Reportserver?%2fNewReports%2fThisMonthAvailability&rs:Command=Render&rc:toolbar=false

All the above will rely on users having access to view reports by being added to the Operations Manager Report Operators user role.

Daniel Savage

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment