O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required