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 user in four ways, as shown in Table 10.1.

Parameters can also be hidden from the user. Although this might sound strange at first, hidden parameters can be used to alter report processing based on the input from other parameters, or based on the result from a data set.

Table 10.1. Parameter Presentation Options

Control

Number of Values

Control over Values

Text box

1

No

Drop-down

1

Yes

Multiselect

1-N

Yes

Radio list

1

Yes(for Boolean parameters only)




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