Skip to main content
BuyLog In
End-user Documentation
Search in…
Docs > End-User Documentation for DevExpress Reports > Reporting for Web > Report Designer > Shape Report Data > Specify Conditions for Report Elements > Conditionally Filter Report Data
All docs
V25.1
End-User Documentation for DevExpress Reports
Reporting for Desktop
Reporting for Web
Document Viewer
Report Designer
First Look at the Report Designer
Add New Reports
Open Reports
Save Reports
Introduction to Banded Reports
Bind to Data
Create Reports
Configure Design Settings
Use Report Elements
Use Report Parameters
Shape Report Data
Filter Data
Group and Sort Data
Format Data
Specify Conditions for Report Elements
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Change a Band's Visibility
Conditionally Filter Report Data
Conditionally Suppress Controls
Limit the Number of Records per Page
Calculate Summaries
Count Elements and Values
Use Calculated Fields
Lay out Dynamic Report Content
Customize Appearance
Add Navigation
Provide Interactivity
Add Extra Information
Merge Reports
Use Expressions
Localize Reports
Preview, Print and Export Reports
Report Designer Tools
End-User Documentation for DevExpress BI Dashboard

Conditionally Filter Report Data

This document describes how to filter a report’s data based on a specific condition.

  1. Switch to the Field List panel, select the Parameters node and click Add parameter.

  2. Specify the parameter name and description, set its type to Number (decimal).

  3. Select the report’s detail band, switch to the Expressions panel and click the Visible property’s ellipsis button.

  4. In the invoked Expression Editor, specify the visibility condition:

    Iif( [UnitPrice] >= ?minUnitPrice, true, false)

    The expression above makes the Visible property return True or False depending on whether the field value is greater or equal to the specified parameter value.

  5. Switch to Print Preview to see the result.