Summary

In this chapter you discovered that Integration Services isn't the only stellar example of product feature integration for enterprise business intelligence software. Indeed, Microsoft's Reporting Services provides an awesome platform to round out the business intelligence lifecycle. Specifically, this chapter covered three scenarios; first, there was an introduction to Reporting Services by way of building a report on a relational database. Then, you created a report on top of a UDM, which showed some of the great integrated features of Reporting Services such as drag-and-drop-based query generation and retrieving dimension and cell properties for inclusion in a report. You learned some of the key enhancements in Reporting Services 2005 such as custom aggregates, retrieving extended properties, and the ability to manage report servers and setup security for your reports. Finally, you learned to create a report model from Analysis Services database and to generate ad-hoc reports using the Report Builder application. If you need an in depth understanding of Reporting Services 2005 we recommend you read the book Professional SQL Server 2005 Reporting Services by Paul Turley, et al. (Wiley, March 2006).