Conditionally Hide Bands

Bands may be conditionally hidden. In this example the Group Header and Detail bands will be hidden if a grouping field meets a certain condition.

Note: No scripts are required to accomplish this task.

1. Create a new report.

2. Bind the report to a data source.

3. Add a Group Header band to the report.

4. Right-click anywhere on the report, and in the Context menu, point to Insert band and click GroupHeader.

   

5. Drag the field which will be used as a grouping criteria from the Field List onto the created GroupHeader1 band.

   

6. 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.

   

7. In this window, click Add to add a new grouping field, and set its Field Name property to the required field.

8. To apply the settings and close the window, click OK.

9. Drag the fields representing the general report's data onto the report's Detail band from the Field List.

   

10. Select the Group Header band's strip, and in the Property Grid, locate the Formatting Rules property, and click the ellipsis.

11. In the Formatting Rules Editor, click Edit Rule Sheet.

    

12. In the Formatting Rule Sheet Editor, click , to create a new rule.

13. Then set its Visible property to No, and for the Condition property, click the ellipsis.

    

14. Construct the required boolean expression to be met (for example, [ShipCountry] == 'Argentina'), and click OK.

    

15. Click Close to close the Formatting Rule Sheet Editor.

16. 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.

17. Repeat this step for the report's Detail band (for example, 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.

    

18. 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.