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.