Skipping Lines After Groups

How To Format Reports Containing Calculations › Skipping Lines After Groups

Skipping Lines After Groups

In this step, you specify how many blank lines you want CA OLQ to display between report groups.

You can indicate a different spacing for each group level. If your report contains more than one group level, you must establish the current group field and group level before you can indicate how many lines you want to skip.

Step	What To Do	How To Do It
1	Proceed 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 next to Group by: Type the corresponding level number in the Level# field. Press [Enter].
3	Specify how many lines you want displayed after the current group.	Enter the number next to Skip lines after group.

Step

What To Do

How To Do It

Proceed 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 next to Group by:
Type the corresponding level number in the Level# field.
Press [Enter].

Specify how many lines you want displayed after the current group.

Enter the number next to Skip lines after group.

If you're not sure how to specify your group field and level, they are listed in the COMPUTE statement on the Report Format - Group By screen. For example:

If your COMPUTE statement reads:

   'EMPLOYEE.PROJECT-COUNT'=COUNT
   GROUP BY EMPLOYEE.PROJECT LEVEL 2'

Your group field is:

   EMPLOYEE.PROJECT

Your group level is:

   2

Specify employee.project as the current group field. Specify 2 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: employee.project Level# 2 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 to skip 0 lines after each project group.

CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 2 136000 Specify summary computations and press the ENTER key Group by: EMPLOYEE.PROJECT Level# 2 Seq Sum Avg Max Min Count X 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 0 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=PICTURE

CA OLQ doesn't insert any blank lines between project groups.

CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 104009 DISPLAY RIGHT to see more report columns 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE REPORT mm/dd/yy DEPT-ID PROJECT EMP-LAST-NAME ─────── ────────────────────────────── ─────────────── 4000 EVALUATE ZEDI ─────────── COUNT FOR EVALUATE: 1 PLANNING ANGELO JACKSON MCDOUGALL PENMAN ─────────── COUNT FOR PLANNING: 4 TESTING BANK ─────────── COUNT FOR TESTING : 1 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT