O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required