Chapter 21. Building Reports for SQL Server 2008 Reporting Services

In this chapter, we take a look at the mechanics of creating reports based on SQL Server 2008 Analysis Services (SSAS) objects: OLAP cubes and data mining models. To that end, we examine using the included MDX Query Designer. Then we take a look at parameter configuration. We conclude this chapter by looking at the redesigned Report Builder report creation tool that Microsoft released in October 2008.

We start by introducing best practices related to using the MDX Query Designer that is included with the SQL Server 2008 Reporting Services (SSRS) developer interface in Business Intelligence Development Studio (BIDS). This is a good starting point because, of course, implementing ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.