Microsoft® SQL Server™ 2005 Reporting Services Step by Step

Chapter 7. Building Advanced Reports

After completing this chapter, you will be able to:

• Create a report parameter to use as a variable for calculating values in a report.

• Pass a report parameter to a query to filter data at the source.

• Use a report parameter to filter a dataset or a data region in the report.

• Use interactive features to navigate within a report or to jump to information located elsewhere.

• Work with hierarchical data.

In the previous chapter, you created a variety of reports to explore the different ways that data can be organized into data regions. In this chapter, you’ll turn your attention to employing advanced techniques to manipulate data in the report. You’ll work with report parameters to allow a user to change a report on demand. ...