How to Make a Report from a Table

In this chapter In this chapter, you create a report that retrieves data from a table. The following report displays data stored in the EMPLOYEE table.

CA OLQ Release nn.n *** Display Report *** -> Line 1 125004 press the ENTER key for DISPLAY/FORMAT ACTIVITY selections EMPLOYEE REPORT mm/dd/yy EMP-LAST-NAME DEPT-ID SALARY-AMOUNT PROJECT --------------- ------- ------------- -------- BANK 4000 80000.00 TESTING ANGELO 4000 18000.00 PLANNING MCDOUGALL 4000 18000.00 PLANNING PENMAN 4000 39000.00 PLANNING JACKSON 4000 34000.00 PLANNING ZEDI 4000 37000.00 EVALUATE END OF REPORT - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 10=LEFT 11=RIGHT

What is a table?

A table is a systematic arrangement of data in rows and columns:

Each row contains related information about a particular item. For example, data about an employee named Jackson.
Each column represents a category of information. For example, each employee's last name.

In other words, columns are attributes associated with each row. Each row contains one entry for each column.

Figure 3-1 on page 3-4 shows a table containing information about employees.

The EMPLOYEE table:

┌──────────────────────────────────────────────────────────────────────┐
│                          EMPLOYEE Table                              │
├────────┬────────────────┬────────────────┬────────────┬──────────────┤
│ EMP-ID │ EMP-LAST-NAME  │ EMP-FIRST-NAME │ START-YEAR │ DEPT-HEAD-ID │
├────────┼────────────────┼────────────────┼────────────┼──────────────┤
│ 0075   │ Lanzarotta     │ Jennifer       │ 78         │ 0003         │
│ 3302   │ Elopoulos      │ Bart           │ 67         │ 0004         │
│ 3871   │ Mahoney        │ Reginald       │ 90         │ 0007         │
│ 4230   │ Ho             │ Duc            │ 91         │ 0011         │
│ 6264   │ Ortega         │ Daniel         │ 91         │ 0013         │
│ 6348   │ Jones          │ Edith          │ 85         │ 0015         │
├────────┼────────────────┼────────────────┼────────────┼──────────────┤
│ 7170   │ Poznanski      │ Anthea         │ 88         │ 0030         │
├────────┼────────────────┼────────────────┼────────────┼──────────────┤
│ 8939   │ Sahu           │ Ankur          │ 77         │ 0321         │
│ 8957   │ Sternbach      │ William        │ 82         │ 0349         │
└────────┴────────────────┴────────────────┴────────────┴──────────────┘

The EMP-ID column represents one category of information on the EMPLOYEE table. Each row represents one data occurrence, which includes all the information about one employee.