How To Format Reports Containing Calculations

In this chapter This chapter shows you how to enhance the appearance of groups and group calculations in your CA OLQ report. Using CA OLQ, you can:

Specify how many lines you want to skip after a group
Specify which character you want to use to set apart computations
Tailor your computation headings
Display only lines containing computations
Display all lines except those containing computations
Skip pages after a group

The report shown below illustrates some of the ways you can format your computations using CA OLQ.

CA OLQ Release nn.n *** Display Report *** -> Page 2 Line 13 125004 Press the ENTER key for DISPLAY/FORMAT ACTIVITY selections EMPLOYEE REPORT mm/dd/yy EMP-LAST-NAME SALARY-AMOUNT ─────────────── ─────────────────────────────────── CLOTH 38000.00 KASPAR 31000.00 FINN 45000.00 TIME 33000.00 WILCO 80000.00 ─────────── AVERAGE SALARY: 45400.00 ___________ TOTAL SPENT IN SALARIES: 453000.00 - 2 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 10=LEFT 11=RIGHT top=no.Key Terms

Here are a few terms used to discuss formatting report groups and calculations:

Detail line

A report line that displays a row of data retrieved from the database. A detail line can contain a computed column, but does not contain a group computation.

Group computation

A calculation that CA OLQ performs on a report group.

Separator character

A character used to separate group computations from the rest of the report.

Summary computation

Another term for group computation.

Summary line

A report line that displays a group computation.

This section contains the following topics:

Creating Your Report

Skipping Lines After Groups

Specifying a SCparator character

Giving Your Computation a Heading

Displaying Only Summary Computations

Displaying Only Detail Lines

Skipping To a New Page After Computations