Conditionally Filter Report Data

• Mar 20, 2023

This document describes how to filter report data based on the specified condition.

Start with a new report bound to the Products field of the sample Northwind Database.

Do the following:

1. Switch to the Field List, right-click the Parameters node, and add a new report parameter:

   

2. Specify the parameter description and set its type to Number (32 bit integer).

   

3. Select the control and click the f button to invoke the Expression Editor. Enter the following expression for the Visible property:

   Iif([UnitPrice] <= ?minUnitPrice, False, True)
   

   

4. Switch to preview mode and view the report, which displays only those items whose unit price is higher than the specified parameter value: