Summary


Over the course of this chapter, you have learned what report parameters are and how they can be used. This includes their use in queries or in expressions that can be used throughout the report.

Parameters allow for dynamism by adding user input to the report-rendering process. A number of parameter options as well as a number of ways SSRS prompts the user are available using familiar controls. Parameters can be data-driven, or they can have a static list of valid values.

After being entered, a parameter can be used as a parameter for a data set's query or anywhere within the report as a part of an expression.

SSRS 2005 adds multivalued parameters that can be used in the WHERE clause of a data set query( WHERE PC.ProductCategoryID in (@ProductCategory) ) or within an expression ( =Parameters!ProductCategory.Value(0)) .



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net