SQL Reporting Services

A customer requested a posibility to get an overview of all available team sites and their sizes on a periodic basis. To fullfill this request I looked into the possibilities of SQL Reporting Services. I installed it as a test on our development Sharepointenvironment together with the Report Pack for Sharepoint 2003. This report pack consists of sql scripts which create the databasesin which the Sharepoint data will be stored, a data extraction tool and example reports.

Steps to install and configure SQL Reporting Services:

• Install SQL Reporting Services


• Install SP2


• Install SQL Server Report Pack for SPS2003


• Run scripts to create databases


• Config data extraction tool (edit config)


• Edit supplied batch with extraction tool


• Perform http://support.microsoft.com/default.aspx?scid=kb;en-us;906508


• Install LogParser


• Configure SQL Reporting Services


• Create data source


• Import sample reports


• Create and install own reports

With Reporting Services you can enable users to log onto a website and run the reports. The users can even configure Reporting Servicesto mail the reports to themselfs periodically via a scheduler.

More information:

• Reporting Services


• SQL Server 2000 Reporting Services Service Pack 2 (SP2)


• Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003