Share a report with other users

  • Article

Applies To: Operations Manager 2007 R2

Microsoft SQL Server Reporting Services (SSRS) report files are stored under the My Reports folder; reports in that folder are available only to their respective creator. Microsoft System Center Operations Manager 2007 searches the SSRS My Reports folder for report files. Report files that are found are then displayed in the console, in the Reporting pane.

If you created a report, you can extend the availability of that report to other users by storing the report file in a custom folder within SSRS.

In this sample scenario, initially, a newly published Availability report is stored in the SSRS My Reports folder and is therefore available only to the user who published it. To share that report with other users, you need to move it to a new, custom folder within SSRS that is viewable to all other users.

To share a report with other users

  1. Open Internet Explorer, and then open the SQL Server Reporting Services (SSRS) home page by entering the following URL: http://<servername>|localhost>/reports.

  2. On the SQL Server Reporting Services Home page, click New Folder.

  3. On the New Folder page, fill in a Name and a Description for the new folder and then click OK.

  4. Back on the Home page, select the My Reports folder.

  5. On the My Reports page, click your published report to run the report.

  6. In the report results page, select Properties.

  7. On the General page, click Move and then select the custom folder that you previously created. Click OK. Click Home to go back to the Home page.

  8. On the Home page, click the My Reports folder.

    On the My Reports page, click Show Details. Select the Edit button that corresponds to the report's .rpdl file. In the file .rpdl page, click Move, and then select the same custom folder that you previously created. Click OK.

  9. In the Operations console, select Reporting.

  10. In the Reporting pane, expand Reporting, and then select the custom folder that you previously created.

    The report is displayed in the results pane and is now available to all users with appropriate reporting access.