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 live online training, plus books, videos, and digital content from nearly 200 publishers.