Conditionally Hide Bands

Conditionally hides a band using a condition based rule. In the example, the GroupHeader and Detail bands are 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. Click the Print Preview tab to display the result.

   

4. Click the Smart tag symbol at the top of the GroupHeader band to display the Tasks window.

   

5. Click the ellipsis next to Group Fields to display the GroupField Collection Editor window.

   

6. Click Add to add a new entry.

7. Set the Field Name property to the required field.

8. Set the Sort Order property (ascending or descending).

9. Click OK to apply the settings and close the Group Field Collection Editor window.

10. Click the GroupHeader band.

11. On the Properties window, click the Appearance tab.

    

12. Click the ellipsis next to Formatting Rules to display the Formatting Rules Editor window.

    

13. Click Edit Rule Sheet to display the Formatting Rule Sheet Editor window.

    

14. Click Add a formatting rule to create the new rule and define the rule properties.

15. Define the display format. In the example, the field Visible is set to No which means that the information does not display in the report if the condition is satisfied.

16. Click the ellipsis next to Condition to display the Condition Editor window.

    

17. Define the Boolean condition. In the example, the fields are formatted if the [Design Equipment_Owner] field is equal to 114-EQUIP.

18. Click OK to save the condition and close the Condition Editor window.

19. Click Close to save the formatting rule and close the Formatting Rule Sheet Editor window.

20. Use the arrow buttons to move the currently selected rule in the Rules available in a report list to the Rules applied to a control list.

    Note:
    Multiple formatting rules can be applied. Rules are applied in the order that they display in the list, the last rule in the list has the highest priority. Use the up and down buttons to modify the rules priority.

21. Click OK to apply the formatting rules and close the Formatting Rules Editor window.

22. Click the band or control to associate the formatting rule, (in this example, the Detail band).

23. On the Properties window, click the Appearance tab.

    

24. Click the ellipsis next to Formatting Rules to display the Formatting Rules Editor window.

    

25. Use the arrow buttons to move the currently selected rule in the Rules available in a report list to the Rules applied to a control list.

    Note:
    Multiple formatting rules can be applied. Rules are applied in the order that they display in the list, the last rule in the list has the highest priority. Use the up and down buttons to modify the rules priority.

26. Click OK to apply the formatting rules and close the Formatting Rules Editor window.

27. Click the Print Preview tab to display the result.

    

    Note:
    In the Print Preview, note that the 114-EQUIP category no longer displays in the report.

Refer to Create Layout Template / Report Definition and Bind Report to Dabacon Project Data for further information.