Which statements define an Easytrieve report?

REPORT starts the layout block. TITLE, LINE, CONTROL, SUM, SEQUENCE, LINESIZE, and PAGESIZE live in that block. PRINT in the JOB activity sends a record to the report by name.

Where does the REPORT block go?

At the end of the JOB, after the activity statements and job procedures. Report procedures such as BEFORE-LINE follow the REPORT block they belong to.

Do I need SUM if I want department totals?

CONTROL is enough to trigger the break. Quantitative fields on LINE are totaled unless SUM lists a smaller set. Add SUM when only some of the amount columns should accumulate.

Can one JOB have two reports?

Yes. Give each REPORT a different name, finish one block (and its report procedures) before the next REPORT, and PRINT the name you want for each record.

Easytrieve Report Statements Cheat Sheet - REPORT, TITLE, LINE, CONTROL, SUM

Easytrieve Report Statements Cheat Sheet

Report statements split the work. PRINT, in the JOB, decides which records appear. REPORT, at the end of the JOB, decides how those records look: page title, columns, breaks, and totals. This sheet lists the verbs you reach for while coding a report. Each row links to the longer tutorial when you need the rules behind the sketch.

Layout statements

Statements inside a report
Statement	Where	Purpose
REPORT	End of JOB	Names the report and opens the layout block
LINESIZE	On REPORT	Characters per line
PAGESIZE	On REPORT	Lines per page before a break
SEQUENCE	In REPORT	Orders detail lines for breaks
TITLE	In REPORT	Page banner
LINE	In REPORT	Detail columns for each printed record
CONTROL	In REPORT	Break field; prints subtotals when it changes
SUM	In REPORT	Which amount fields accumulate at breaks

Activity statement that feeds the report

PRINT
Statement	Where	Purpose
PRINT report-name	JOB logic, usually under IF	Sends the current record to that report
HEADING	On DEFINE, or as a column label	Text above one LINE column

Skeleton

text

1
2
3
4
5
6
7
8
9
10
11
JOB INPUT EMPFILE
  IF STATUS EQ 'A'
     PRINT ACTIVE-RPT
  END-IF
 
REPORT ACTIVE-RPT LINESIZE 132 PAGESIZE 60
  SEQUENCE DEPT
  CONTROL DEPT
  SUM SALARY
  TITLE 'ACTIVE EMPLOYEES'
  LINE EMP-NO NAME DEPT SALARY

SEQUENCE DEPT keeps one department together. CONTROL DEPT prints a subtotal when DEPT changes and a grand total at the end. SUM SALARY totals salary only, even if other numeric columns sit on LINE. The PRINT name and the REPORT name have to match.

Report procedures

BEFORE-LINE, AFTER-LINE, BEFORE-BREAK, and AFTER-BREAK are procedures the report writer calls. Code them immediately after the REPORT block they belong to. The JOB does not PERFORM them.

text

1
2
3
4
5
6
REPORT ACTIVE-RPT LINESIZE 132
  LINE EMP-NO NAME DEPT
 
BEFORE-LINE. PROC
  * runs before each detail line
END-PROC

Width and page

LINESIZE 132 with a SYSOUT record of 133 is a common shop pair. The extra byte is the carriage control.
PAGESIZE counts lines, including room for TITLE. A tight page size collides with headings.
A field with no HEADING prints its field name as the column label.

Checks before you compile

TITLE and LINE are inside REPORT, not in the JOB body.
PRINT's report name exists on a REPORT statement.
CONTROL fields are in SEQUENCE order, major to minor.
SUM lists only the amounts you want on the total line.
The next REPORT starts after this block's procedures, not in the middle of them.

Explain it like I'm five

REPORT is the sheet of paper with the title and the column boxes already drawn. PRINT is choosing a person and saying their numbers go on that sheet. CONTROL is a new sticky note every time the team name changes, with a count of the salaries you asked SUM to add.

Exercises

Copy the skeleton and change SUM so it totals SALARY and BONUS.
Add a second REPORT named EX-RPT and PRINT it when STATUS is not A.
Name three statements that must stay inside REPORT, and one that stays in the JOB.
Set LINESIZE for a 80-column test listing and say what happens if a LINE is wider.

Quiz

Test Your Knowledge

1. PRINT belongs in:

JOB activity logic
The REPORT layout block only
JCL
PARM

2. TITLE versus HEADING:

TITLE is the page banner; HEADING labels a column
They are the same statement
HEADING replaces PRINT
TITLE sets LINESIZE

3. CONTROL on a report field:

Breaks and prints totals when that field changes
Opens the input file
Sets the DD name
Replaces SEQUENCE

4. SUM inside REPORT:

Limits which quantitative fields are totaled
Sorts the input file
Defines a FILE
Starts the compile

5. LINESIZE should agree with:

The spool record length for that SYSOUT
The input BLKSIZE only
The PARM LINK name
The STEPLIB DSN

Layout statements

Statements inside a report
Statement	Where	Purpose
REPORT	End of JOB	Names the report and opens the layout block
LINESIZE	On REPORT	Characters per line
PAGESIZE	On REPORT	Lines per page before a break
SEQUENCE	In REPORT	Orders detail lines for breaks
TITLE	In REPORT	Page banner
LINE	In REPORT	Detail columns for each printed record
CONTROL	In REPORT	Break field; prints subtotals when it changes
SUM	In REPORT	Which amount fields accumulate at breaks

Activity statement that feeds the report

PRINT
Statement	Where	Purpose
PRINT report-name	JOB logic, usually under IF	Sends the current record to that report
HEADING	On DEFINE, or as a column label	Text above one LINE column

Skeleton

text

1
2
3
4
5
6
7
8
9
10
11
JOB INPUT EMPFILE
  IF STATUS EQ 'A'
     PRINT ACTIVE-RPT
  END-IF
 
REPORT ACTIVE-RPT LINESIZE 132 PAGESIZE 60
  SEQUENCE DEPT
  CONTROL DEPT
  SUM SALARY
  TITLE 'ACTIVE EMPLOYEES'
  LINE EMP-NO NAME DEPT SALARY

Report procedures

BEFORE-LINE, AFTER-LINE, BEFORE-BREAK, and AFTER-BREAK are procedures the report writer calls. Code them immediately after the REPORT block they belong to. The JOB does not PERFORM them.

text

1
2
3
4
5
6
REPORT ACTIVE-RPT LINESIZE 132
  LINE EMP-NO NAME DEPT
 
BEFORE-LINE. PROC
  * runs before each detail line
END-PROC

Width and page

LINESIZE 132 with a SYSOUT record of 133 is a common shop pair. The extra byte is the carriage control.
PAGESIZE counts lines, including room for TITLE. A tight page size collides with headings.
A field with no HEADING prints its field name as the column label.

Checks before you compile

TITLE and LINE are inside REPORT, not in the JOB body.
PRINT's report name exists on a REPORT statement.
CONTROL fields are in SEQUENCE order, major to minor.
SUM lists only the amounts you want on the total line.
The next REPORT starts after this block's procedures, not in the middle of them.

Explain it like I'm five

Exercises

Copy the skeleton and change SUM so it totals SALARY and BONUS.
Add a second REPORT named EX-RPT and PRINT it when STATUS is not A.
Name three statements that must stay inside REPORT, and one that stays in the JOB.
Set LINESIZE for a 80-column test listing and say what happens if a LINE is wider.

Easytrieve Report Statements Cheat Sheet

Layout statements

Activity statement that feeds the report

Skeleton

Report procedures

Width and page

Checks before you compile

Explain it like I'm five

Exercises

Quiz

Test Your Knowledge

Related Concepts

REPORT statement

TOTAL

HEADING

Related Pages

Easytrieve Report Statements Cheat Sheet

Layout statements

Activity statement that feeds the report

Skeleton

Report procedures

Width and page

Checks before you compile

Explain it like I'm five

Exercises

Quiz

Test Your Knowledge

Related Concepts

REPORT statement

TOTAL

HEADING

Related Pages