Chapter 12. Building Reports

After completing this chapter, you will be able to:

  • Assemble an MDX query to retrieve data for a Reporting Services report

  • Employ report parameters to limit data returned from Analysis Services

  • Apply proper formatting and aggregation to data within a report

Reporting Services, Microsoft’s enterprise reporting solution, is distributed as part of the Microsoft SQL Server product suite along with Analysis Services. Because of the close affiliation between these products, many developers are first exposed to the MDX language during the development of reports.

Reporting Services reports provide an effective means of presenting Analysis Services data to business users. Although the tools provided make development of reports against ...

Get Microsoft® SQL Server® 2008 MDX Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.