Conditionally Suppress Controls

• Jul 20, 2021

This document describes how to display or hide a report control in a published document based on a specified logical condition.

• Create a check box bound to the Discontinued data field.

  

• Select the required control and switch to the Expressions section in the Visual Studio Properties window. Click the ellipsis button for the control’s Visible property (you can find it under the BeforePrint event’s category if you are using the ExpressionsAdvanced binding mode):

  

• This invokes the Expression Editor where you can specify the required expression:

  

  Use the Iif function to define the required condition. For example:

  Iif([Discontinued] == False, False, [Discontinued])

  This expression means that if the Discontinued data field’s value is False, the control’s Visible property’s value is also False.

When switching to Print Preview, you can view the report control’s visibility changes according to the assigned condition:

Tip

See Hide Table Cells to learn how to conditionally suppress table cells and define the mode for processing them.