Chapter 14. Creating Ad Hoc Reports

After completing this chapter, you will be able to:

  • Use Report Builder to create a table, matrix, or chart report.

  • Enhance the appearance of a Report Builder report with formatting.

  • Create a new field for the report by using an expression.

  • Apply a filter to the report data.

  • Change the sort order of report data.

  • Set report properties to control the use of interactive features.

  • Save a report to the report server.

  • Work with default and custom clickthrough reports.

In Chapter 9, you created a report model to support ad hoc reporting. The report model presents a list of available fields from the data source that the user can include in a report. The report server translates the user’s selection into a query that it uses to ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step 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.