Previous Topic: Step 5— Display your reportNext Topic: Key Terms


How to Format Your Report

In this chapter Using CA OLQ, you can format your report by:

CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. SALARY REPORT FOR CENTRAL DIVISION 03/23/99 DEPARTMENT ID NAME SALARY ───────────── ─────────────── ──────────── 1000 FITZHUGH $13,000.00 JOHNSON $13,500.00 ORGRATZI $39,000.00 PEOPLES $80,000.00 2000 BLOOMER $15,000.00 HUTTON $44,000.00 JENSON $82,000.00 KIMBALL $45,000.00 KING $14,500.00 NICEMAN $14,000.00 3100 DOUGH $33,000.00 - 1 - CREATED BY:SYB 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT

In this chapter, you will:

  1. Create a current report listing employee salary information
  2. Sort your report rows by department ID, and within each department by employee name
  3. Edit your report columns to enhance your report's appearance
  4. Modify the relative positions of your columns
  5. Change the external pictures for some of the data columns
  6. Change the column headers
  7. Change the page headers and footers

This section contains the following topics:

Key Terms

Creating a Report

Sorting Your Report Rows

Editing Your Report Values

Changing Your Column Relative Positions

Changing Your Column Pictures

Changing Column Headers

Making Page Headers and Footers