Chapter 10. Report Parameters

In This Chapter

• Setting Up Parameters

• Parameter Properties

• Data-Driven Parameters

• Parameters and Data Sources

• Expressions with Parameters

• Dynamic SQL with Parameters

• Parameter Dependencies

• Example Using MultiSelect

Report-level parameters can serve a number of functions, including the following:

• Manipulating report data

• Connecting related reports together

• Varying report layout and presentation

Parameters are used to pass information to a report to influence report processing. For example, a parameter can serve as a condition in a WHERE of a query that generates the report’s data set. Parameters are relatively easy to set up and are very flexible.

Report parameters can be presented to the ...

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