21.7 Summary

Congratulations! You have successfully built a report that suppresses labels when no data is retrieved. You now know how to:

  • manually create and link two queries.

  • create a formula column and a summary column.

  • create a default layout in the Report Wizard.

  • create a format trigger that suppresses the field labels when no detail records are displayed.

  • added boilerplate text and manipulated the layout.

For more information on any of the wizards, views, or properties used in this example, refer to the Oracle Reports online Help, which is available in Oracle Reports Builder or hosted on the Oracle Technology Network (OTN), as described in Section 4.1.1, "Using the Oracle Reports online Help".