Data-Driven Parameters


Report parameter values can be driven from a list of valid values. This list can come from a data set. Under Available Values, simply add a list of values for the values to remain hard-coded in the RDL. If you want to drive them from a data source, select From Query. The screen should look similar to Figure 10.2.

Figure 10.2. Query parameter values.

The same holds true for the default values. They can be either data-driven through the same mechanism or hard-coded within the RDL.

The label is the value displayed to the user, whereas the value is the value passed back to the Report Server. For example, this is useful in a query parameter in which you want the user to select a familiar name from a drop-down list, yet the query expects the ID.



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