Microsoft® SQL Server® 2008 Reporting Services Step by Step

Working with Parameters

By using parameters, you can add flexibility to your reports. A common way to use a parameter is to prompt the user for input. For instance, you can use the input value to change the behavior of the report by using it in an expression, as you learned in Chapter 5. Another way to use a parameter is to filter the contents of a report. In this case, you can use the input value either as a filter on a data region or as a query parameter to limit the data retrieved by a dataset.

Prompting the User for Input

You can prompt the user for input using a report parameter in two ways. It’s considered best practice to provide the user with a list of valid values, but you can also let the user simply type a value. When you provide a list ...