Some users may need to have reports that can be looked at regularly but they don't want to install the SCOM console on a bunch of machines and have all those connections to the SDK. So what can you do? One way around this is to create reports that can be viewed in IE. Below is an example I recently used to create a Disk Usage report for Exchange Servers that can be run by the Exchange Admins:
1. Go to Reporting in SCOM Admin Console.
2. Open the report you want to publish, and then fill in the parameters. When specifying the date, use Advanced and then Today Minus 7 (for weekly) etc.
3. Run the report. When finished, select Publish.
4. Open SQL Management Studio, and then create a Reporting Services connection to the SRS box. (In Server Type select Reporting Services instead of Database Engine.)
5. Create a new folder for the reports (ie Exchange Admin Reports).
6. Expand the Home folder, then the Users folder, and then the user who created the report.
7. In their My Reports folder, right click on the report file, select Move and browse to newly created folder. Do the same for the rpdl file.
8. Connect to the report in IE by typing /Reports">http://<machinename>/Reports.
9. Browse to the new folder, and then click the report.
10. Copy the link from the report, and then click Email as link to send it the appropriate group of people.
Note: If you want to hide the parameters fields in the header area, right click on the reports in SQL Management Studio and select Properties. Click on Parameters and then check the box to Hide whichever fields you want hidden. Also, if you don't want the user to see the default tabs in the top of the report (which allows them to go to properties etc. in IE) browse to the report by going to /Reportserver">HTTP://<Machinename>/Reportserver then drill down to the report and use this link.
Note: This information was originally contributed by Sam Allen, Senior Support Escalation Engineer, on the Operations Manager Support Team blog:
http://blogs.technet.com/operationsmgr/archive/2009/07/02/opsmgr-2007-how-to-create-reports-that-can-be-viewed-in-ie-rather-than-the-console.aspx