Reporting
User Guide
Create Reports : Styles and Conditional Formatting : Conditionally Hide Bands
|
•
|
Add a Group Header band to the report.
|
Right-click anywhere on the report, and in the Context menu, point to Insert band and click GroupHeader.
|
•
|
Drag the field which will be used as a grouping criteria from the Field List onto the created GroupHeader1 band.
|
|
•
|
Click the Smart Tag of the GroupHeader1 band, and in the actions list, click the ellipsis in the Group Fields section. The GroupField Collection Editor window is then displayed.
|
In this window, click Add to add a new grouping field, and set its Field Name property to the required field.
|
•
|
Drag the fields representing the general report's data onto the report's Detail band from the Field List.
|
|
•
|
Select the Group Header band's strip, and in the Property Grid, locate the Formatting Rules property, and click the ellipsis.
|
|
•
|
In the Formatting Rule Sheet Editor, click
 , to create a new rule. Then set its Visible property to No, and for the Condition property, click the ellipsis. |
|
•
|
Construct the required boolean expression to be met (e.g. [ShipCountry] == 'Argentina'), and click OK.
|
|
•
|
In the Formatting Rules Editor, move the rule from the Available Rules list to the Applied Rules list (using the > button) to apply it to the band.
|
Repeat this step for the report's Detail band (e.g. click its Formatting Rules property's ellipsis, and in the window, make the same rule apply to this band, as well). Otherwise, only the Group Header band will not be displayed when the rule's condition is met, while the detailed section of this group will still be visible.
Switch to the Preview tab to view the result.
In this example, the Argentina section has not been added to the report as a result of the conditional formatting.
