Progress
Report Builder
Tutorial
Open the Report Definition
For all the previous reports in this tutorial, you had to create the report definition. However, because the report definition for this report contains information that you have already created, it is provided for you. After you have prepared the memo file,
Paylet.txt
, you are ready to use it to generate the form letters.Follow these steps to open the report definition:
Figure 6–13 shows the report layout defined in the Payment Letter Sample report definition.
Figure 6–13: Payment Letter Report Layout
![]()
The Payment Letter report definition provides a basic layout and structure for this form letter by defining many report characteristics and report layout features:
- It includes the All Around Sports logo in the title band line.
- It includes a date field that displays the current system date.
- It provides the customer name and address information fields, including the City–State–PC field you created in the Recall form letter.
- It formats all the database fields in Times New Roman. Because the field representation on the layout is not long enough to accommodate all the characters in the specified font, the fields are represented by x and the number of characters in the field format in parentheses (for example, x(20)).
- It presents all the fields in group footer lines so that Report Builder can calculate the total amount of each customer’s order.
- It prints the All Around Sports address in the page footer band line.
- It sorts and groups the report records by customer number, then by order number.
- It specifies 1-inch page margins.
- It specifies the joins to the tables that contain the fields used in the layout and the fields referenced in the memo file.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |