Microsoft® SQL Server® 2008 Analysis Services Step by Step

Creating Reporting Services Reports

You can create Reporting Services reports that use Analysis Services data. Because SQL Server 2008 Reporting Services is an enterprise reporting solution, your organization’s report developers will be able to create reports from Analysis Services data that can then be distributed to individuals throughout your organization or accessed on demand through a Web browser.

Although Reporting Services provides many features to manage enterprise-scale reporting requirements, Reporting Services reports are not quite as flexible as the Excel 2007 PivotTable and PivotChart features. In a Reporting Service report, you can filter, drill down, drill up, and drillthrough to other reports, but you can’t pivot data and you can’t ...