In this chapter from MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance, you will first learn how to create SSRS projects and reports in Business Intelligence Development Studio (BIDS). You will also see how to develop report objects by using the Report Designer and how to work with advanced report object properties. You will then see how to use a SQL Server Analysis Services (SSAS) database as the source for your report. And last, after looking at how to create a dataset from a data source, you will learn how to apply dataset filters and groups.

SQL Server Reporting Services (SSRS) plays an important role in the Microsoft SQL Server 2008 business intelligence (BI) platform. Reports built in SSRS query relational and multidimensional databases and other data sources and distribute information throughout the organization. In SQL Server 2008, SSRS features significant enhancements. You can create interactive reports that contain rich data regions, including the new Tablix report item, charts, and gauges. In this chapter, you will first learn how to create SSRS projects and reports in Business Intelligence Development Studio (BIDS). You will also see how to develop report objects by using the Report Designer and how to work with advanced report object properties. You will then see how to use a SQL Server Analysis Services (SSAS) database as the source for your report. And last, after looking at how to create a dataset from a data source, you will learn how to apply dataset filters and groups.