This recipe will use the parameters added in the previous recipe and influence the report. From the two parameters added, the Boolean type will be used to show or hide the chart data region while the string type will be used to restrict the data shown in the table data region.
Select the CustTransPie chart data region and open its properties.
In the visible property, key in the following expression. This links the first parameter to control the visibility of the data region:
=IIF(Parameters!ShowPieChart.Value, True, False)
Navigate to the Filters node of CustTransTable and create a new filter.
In the new filter node, set the following properties:
Property
Value
Name
CustGroup
Value
=1
Expression
=IIF((Parameters!CustGroup.Value=Fields!CustGroup.Value),1,0)
The data region displays only the data for which the expression evaluates to 1.
Now that the report is finally over, select Preview and activate the Parameters tab. The parameters that...