Tutorial: Adding Parameters to Filter Report Data (Report Builder 2.0)
In a report, parameters are used to filter data, vary appearance, and connect to related reports. When you create a report parameter and run a report, you enable the user to choose values for the report parameter. In your report, you can write expressions that refer to the value of the parameter at run time and change the data or appearance of the report. Parameters are also used when you include a link to another report or to a subreport from your main report.
This tutorial is designed to help you explore how parameters can be used to control content and appearance in a basic table report, and to show you how to pass parameters from a main report to a drillthrough report.
What You Will Learn
In this tutorial, you will add parameters to the report you created in the previous tutorial, Tutorial: Creating a Basic Table Report (Report Builder 2.0). You will learn the following concepts:
How adding query parameters to a dataset query automatically creates report parameters. This filters data at the data source.
How to filter data after it is retrieved from the data source.
How to provide a list of valid values for single and multivalue parameters.
How to include the values a user chooses for a single or multivalue parameter in an expression in your report.
How to add cascading parameters, whereby a user chooses a value for the first parameter, and the next parameter displays only values that are valid for that choice.
How to pass parameters to a drillthrough report from the main report.
Requirements
You must have the following prerequisites to complete this tutorial:
- You must have access to the Sales Order report that you created in the previous tutorial. For more information, see Tutorial: Creating a Basic Table Report (Report Builder 2.0).
Estimated time to complete this tutorial: 60 minutes
Tasks
Lesson 1: Adding Parameters to Filter Reports by Date (Report Builder 2.0)
Lesson 2: Adding Parameters to Create a List of Available Values (Report Builder 2.0)
Lesson 3: Adding Parameters to Select Multiple Values in a List (Report Builder 2.0)
Lesson 4: Adding Cascading Parameters (Report Builder 2.0)
Lesson 5: Adding Parameters to Pass to a Drillthrough Report (Report Builder 2.0)