Now that you’ve had a chance to understand the vast array of BI features—both those built into SharePoint Server 2007 and those additional BI products that can be integrated into SharePoint Server 2007 for enhanced data analysis and reporting—let’s consider which features you should use in specific scenarios and how to use them properly.
The following recommendations do not include programmable solutions, such as using the SharePoint Server 2007 SDK or other XML/Web service–based solutions.
Scenario I. I have existing Reporting Services reports I want to have exposed in SharePoint Server 2007.
How you do this depends on your existing SQL Server version. If you are running SQL Server 2005 Service Pack 2, ...