Progress
Report Builder
Tutorial


Manipulating Fields on the Layout

Now that you have created all the band lines, you are ready to start moving and inserting fields on the layout. You will perform the following steps:

  1. Change how Report Builder represents fields on the layout.
  2. Delete the unnecessary fields on the layout.
  3. Move the fields currently on the layout
  4. Insert the user-defined fields on the layout.
  5. Insert text fields on the layout.
  6. Format the fields.
Displaying Field Names Instead of Field Formats on the Layout

By default, Report Builder represents fields by their format. However, because you have multiple fields on the layout that have the same format, change the representation to the field name.

Choose View Field Names. Report Builder displays the field names instead of the field formats on the report layout.

Deleting the Unnecessary Fields on the Layout

When Report Builder creates the report layout with the Instant Layout option, it creates two fields that you do not need for this report.

Follow these steps to delete the unnecessary fields:

  1. Delete the Order text field from the first title band line.
  2. Delete the Printed: text field and Date_rb and Time_rb fields from the second title band line.
  3. Delete the Records printed: text field and Recno_rb field from the second summary band line.
Moving the Fields Currently on the Layout

The next task is to relocate the fields that are currently on the layout to better positions on the layout.

Follow these steps to move the fields:

  1. Move the Sales–Rep text field from the page header band line to the left margin of the third 1GH–Sales–Rep group header band line.
  2. Move the Sales–Rep field to the 1-inch mark on the third Sales–Rep group header band line. Because the Sales–Rep field name is longer than the field width, only the first three letters show.
  3. Move the Order–num text field to the left margin of the fifth 1GH–Sales–Rep band line.
  4. Move the Order–num field to the left margin of the 2GF–Order–num band line.

When you finish moving the fields currently on the layout to their new positions, the layout should look like the one shown in Figure 7–4.

Figure 7–4: Commission Report Layout with Fields in New Positions

Inserting the User-defined Fields on the Layout
  1. Press the right mouse button to access the Insert Fields dialog box.
  2. Activate the Include Field Label toggle box. When Report Builder inserts each field, it automatically places the corresponding field label on the band line directly above the band line containing the field.
  3. Insert the fields at the positions indicated in the following table. Position the right edge of the field at the specified ruler mark:
  4. Field
    Band Line
    Ruler Mark
    Order–Total
    First 2GH–Order–num
    2.5-inches
    Comm–Amt
    First 2GH–Order–num
    5-inches
    Sales–Rep–Total
    Third 1GF–Sales–Rep
    2.5-inches
    Comm–Total
    Third 1GF–Sales–Rep
    5-inches
    Percent–of–Total
    Fifth 1GF–Sales–Rep
    2.5-inches
    Comm–Bonus
    Sixth 1GH–Sales–Rep
    2.5-inches
    Grand–Total–Sales
    Second summary
    2.5-inches
    Grand–Total–Comm
    Second summary
    5-inches

  5. Close the Insert Field dialog box.
  6. Move the field labels to the positions indicated in the following table. Position the left edge of the field at the specified ruler mark:
  7. Label
    Band Line
    Ruler Mark
    Sales–Rep–Total
    Third 1GF–Sales–Rep
    Left margin
    Comm–Total
    Third 1GF–Sales–Rep
    3-inches
    Percent–of–Total
    Fifth 1GF–Sales–Rep
    Left margin
    Comm–Bonus
    Sixth 1GH–Sales–Rep
    Left margin
    Grand–Total–Sales
    Second summary
    Left margin
    Grand–Total–Comm
    Second summary
    3-inches

After you insert all eight fields, the report layout should look like the one shown in Figure 7–5.

Figure 7–5: Commission Report Layout with User-defined Fields

Preview the report. If your layout looks like the one shown in Figure 7–5 and you correctly defined all the user-defined fields, the report looks like the one shown in Figure 7–6.

Figure 7–6: Preview of Commission Report with User-defined Fields

Inserting Text Fields on the Layout

You must create text fields for the title and summary information. After you create the fields, you will center the title information on the band lines.

Follow theses steps to create the text fields:

  1. Type COMMISSION REPORT on the second title band line.
  2. Type Commission and Sales for 1/1/95 to 6/30/95 on the fourth title band line.
  3. Type For orders less than $2,000, commission rate is 5%; for orders greater than $2,000, commission is 10% on the fifth summary band line.
  4. Select the second, third, and fourth title band lines.
  5. Choose Properties Band Line Justify. The Band Line Justify dialog box appears.
  6. Choose Center, then choose OK.

The report layout should look like the layout shown in Figure 7–7.

Figure 7–7: Commission Report Layout with Title and Summary Information


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095