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

 

1.Select the required control and switch to the Property Grid. Open the Behavior tab, click the Visible property's marker and select Visible Expression in the context menu.

2.In the invoked Expression Editor, 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 data field's value is False, the control's Visible property is disabled.

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

Note

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