Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Detailed Guide to DevExpress Reporting > Shape Report Data > Shape Data (Expression Bindings) > Conditionally Change a Band's Visibility
A newer version of this page is available. .
All docs
V19.1
Reporting
Product Information
Get Started with DevExpress Reporting
Create Popular Reports
Detailed Guide to DevExpress Reporting
Introduction to Banded Reports
Provide Data to Reports
Use Report Controls
Shape Report Data
Filter Data
Group and Sort
Shape Data (Expression Bindings)
Format Data
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Filter Report Data
Conditionally Suppress Controls
Limit the Number of Records per Page
Conditionally Change a Band's Visibility
Calculate a Summary
Calculate an Advanced Summary
Calculate a Weighted Average
Display Row Numbers in a Report, Group or Page
Count the Number of Records in a Report or Group
Count the Number of Groups in a Report
Shape Data (Legacy Data Bindings)
Use Calculated Fields
Use Report Parameters
Arrange Dynamic Report Contents
Customize Appearance
Add Navigation
Provide Interactivity
Add Extra Information
Merge Reports
Use Expressions
Store and Distribute Reports
Reporting API
Visual Studio Report Designer
Create End-User Reporting Applications
Reporting in .NET Core 3 (CTP)
API Reference
ASP.NET Core API Reference
Client API Reference
Client API Reference (WebForms & MVC)
Download CHM

Conditionally Change a Band's Visibility

  • 2 minutes to read

This topic describes how to change report band visibility.

Note

You can use this approach to conditionally change the band’s visibility when the UserDesignerOptions.DataBindingMode is set to DataBindingMode.Expressions or DataBindingMode.ExpressionsAdvanced.

See Conditionally Change a Band’s Visibility to learn about the legacy approach to solving this task.

See Data Binding Modes to learn more about the available binding modes.

Set a band’s Visible property to an expression to conditionally change the band’s visibility based on a field’s value or a parameter.

The report created in this tutorial contains two Detail sub-bands with different report controls. These sub-bands are used to display discontinued and current products.

1

Follow the steps below to see how to change sub-band visibility based on the Product‘s Discontinued field value.

  1. Bind your report to the Products table from the Northwind database.

  2. Add two Sub-bands to the Detail band, and drag the XRLabel from the Toolbox to the first sub-band and XRTable to the second sub-band.

    2

    Bind Label1 and TableCell1 to the ProductName field. Add an XRPictureBox control to the TableCell2 and specify its ImageSource property. This picture will serve as an indication of discontinued products.

    3

  3. Select SubBand1 and switch to the Visual Studio property grid. Switch to its Expressions section and click the Visible property’s ellipsis button.

    In the invoked Expression Editor, specify the Iif(![Discontinued], true, false) expression.

    This expression sets the Visible property to True or False based on the Discontinued data field’s value.

    4

    Do the same with SubBand2. But use the [Discontinued] expression.

    5

As a result, Print Preview displays how changes to band visibility influence the Product List. The SubBand1 is used to display products that have the Discontinued field set to false, and the SubBand2 is used to display discontinued products.

6