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 ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.