Integrating SCOM 2007 Reports into WSS 3.0

Hi All,

Has anybody integrated SCOM 2007 Reports into Windows SharePoint Services 3.0? 

Is it neccessary to install the Sharepoint Reporting Services Ad-In for SQL 2005?

Any ideas or comments?

Regards,

Ruaan 

If anyone tracks need based on number of posts, then I am interested in this topic solution as well.

jeff

Hi All,

I have been looking around on the internet and found the following. There is a Reporting Services web part that you can download and install in WSS 3 which you then configure  to point to your reporting server hosting the scom reports. http://blogs.sqlxml.org/bryantlikes/articles/628.aspx

The link on the web site that points to the download location of the RsWebParts cab file is broken so I found it at http://sourceforge.net/projects/rswebparts

It looks like it is possible to install the sql 2005 reporting services add-in for WSS 3.0 but you need to install it in the following way.

1. First Install WSS 3.0

2. Then install reporting services with service pack 2 and configure reporting services in sharepoint integrated mode.

3. Then install the sql 2005 sharepoint services add-in. This will add the reporting services feature in the WSS 3.0 Admin console.

4. Go to the WSS 3 Admin console, Application management and you will see reporting services. Point your server to the scom reports server and database.

5. Design a web part page that shows your scom 2007 reports.

Cheers,

Ruaan

Hi All,

I have found this handy link that will help with integrating reports into SharePoint.

http://blogs.technet.com/momteam/archive/2008/02/29/publish-reports-to-sharepoint.aspx

Cheers