31.7 Summary

Congratulations! You have successfully built a report with spelled-out cash amounts on the check, as well as the payment and order details on the check stub. You now know how to:

  • use the Report Wizard to create a simple report definition.

  • use the tools in the Paper Layout view to import a blank check image and add fields to the report.

  • create a PL/SQL function that returns spelled-out numbers.

  • create a formula column based on a PL/SQL function.

  • use the tools in the Data Model view to link two queries.

  • use the tools in the Paper Design view to format your check printing report to print on a desired check.

  • create a check stub that displays a duplicate of the information on the check.

  • use the Report Block Wizard to create a simple tabular report that displays order details on a check stub.

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