Monday, August 27, 2007

Using SSRS/SSIS to Report on SharePoint Data

Good information...we are often asked for reports o our portal.

"To effectively report on SharePoint data using SQL Server Reporting Services (SSRS) you must copy the data into SQL Server using SSIS. Unfortunately, SharePoint out of the box does not have a solution for reporting on its own data other than configuring list views or building data views. Building a reporting database gives developers a powerful toolkit for building high-performance reports while off-loading the burden of report processing from SharePoint. "

No comments:

Post a Comment