Specifying a SCparator character

How To Format Reports Containing Calculations › Specifying a SCparator character

Specifying a SCparator character

In this step, you specify which character you want to use to set your group calculations apart from the rest of your report.

CA OLQ provides lines separating your group calculations from the detail lines in your report. The default separator characters that make up these lines are:

A hyphen (-) for subtotals
An equal sign (=) for report totals

You can change these default separator characters to modify your report's appearance.

Each group level's separator character is modified individually. Before you can specify a separation character, you must establish a current group field and level.

Step	What To Do	How To Do It
1	Go to the Report Format - Group By screen.	Type group by in the command line of any screen.
2	Establish the current group field and level.	Type the group field in the Group by entry. Type the corresponding level number in the Level # field. Press [Enter].
3	Specify your separator character.	Type the character you want in the Separator character field.

Step

What To Do

How To Do It

Go to the Report Format - Group By screen.

Type group by in the command line of any screen.

Establish the current group field and level.

Type the group field in the Group by entry.
Type the corresponding level number in the Level # field.
Press [Enter].

Specify your separator character.

Type the character you want in the Separator character field.

Specify all as your current group field. Specify 1 as the current group level.

CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 2 136000 Specify summary computations and press the ENTER key Group by: all Level# 1 Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME 3 _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 4 _ _ _ _ X PROJECT 2 _ _ _ _ COMPUTE FIELDS: X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM OUNT) GROUP BY ALL LEVEL 1 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=PICTURE

CA OLQ echoes the screen, listing the current group field and level. Specify that you want the underscore (_) to set apart the report total.

CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 2 136000 Specify summary computations and press the ENTER key Group by: ALL Level#1 Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME 3 _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 4 X _ _ _ X PROJECT 2 _ _ _ _ COMPUTE FIELDS: X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM OUNT) GROUP BY ALL LEVEL 1 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Skip lines after group 1 Separator character _ Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=PICTURE

You may have to scroll forward (PF8) to view this computation. Underscores separate the report total computation from the preceding detail lines.

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 PROJECT EMP-LAST-NAME SALARY-AMOUNT ────────────────────────────── ─────────────── ───────────────────────── EVALUATE CLOTH 38000.00 KASPAR 31000.00 ─────────── COUNT FOR EVALUATE: 2 RESEARCH FINN 45000.00 TIME 33000.00 WILCO 80000.00 ─────────── ─────────── COUNT FOR RESEARCH: 3 AVE FOR 5200 : 45400.00 ___________ 453000.00 - 2 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 10=LEFT 11=RIGHT