PRINT
The PRINT statement produces output from a REPORT routine.
BYTE variable is the identifier of an 4GL variable of data type BYTE.
filename is a character string, enclosed between quotation ( " ) marks, and specifying
the name of an ASCII file to include in the output from the report. The filename can include a
path name.
left offset is an expression that evaluates to a positive whole number, specifying a
character position offset (from the left margin) no greater than the difference
(right margin - left margin).
relative offset is an expression that evaluates to a positive whole number, specifying an
offset (from the current character position) no greater than the difference (right
margin - current position).
temporary is an expression that evaluates to a positive whole number, specifying the
absolute position of a temporary right margin.
TEXT variable is the identifier of an 4GL variable of the TEXT data type.
This statement can include character data in the form of an ASCII file, a TEXT
variable, or a comma-separated expression list of character expressions in the
output of the report. (For a TEXT variable or filename, you cannot specify
additional output in the same PRINT statement.) You cannot display a BYTE value.
Unless its scope of reference is global or the current module, any program
variable in expression list must be declared in the DEFINE section.
Output is sent to the file, pipe, or device specified in the REPORT TO clause
of the OUTPUT section, or in the TO clause of the START REPORT statement of the calling routine.
Otherwise, the screen displays the output.
Aggregate Report Functions
Aggregate report functions summarize data from several records in a report.
The syntax and effects of these functions in a report resemble those of SQL
aggregate functions, but are not identical.
The expression (in parentheses) that SUM( ), AVG( ), MIN( ), or MAX( ) take as
an argument is typically of a number or INTERVAL data type; large binary and
structured data types are not valid. The AVG( ), SUM( ), MIN( ), and MAX( )
aggregates all ignore records for which their arguments have NULL values, but each
returns NULL if every record has a NULL value for the argument.
The GROUP Keyword
This optional keyword causes the aggregate function to include data only for a group of records that have the same value on a
variable that you specify in an AFTER GROUP OF control block. An aggregate
function can only include the GROUP keyword within an AFTER GROUP OF control block.
The WHERE Clause
The optional WHERE clause allows you to select among records passed to the
report, so that only records for which the Boolean expression is TRUE are included.
The AVG( ) and SUM( ) Aggregates
These evaluate as the average (that is, the arithmetic mean value) and the
total (respectively) of expression among all records, or among records qualified
by the optional WHERE clause and any GROUP specification.
The COUNT ( * ) and PERCENT ( * ) Aggregates
These return, respectively, the total number of records qualified by the
optional WHERE clause, and the percentage of the total number of records in the
report. You must include the ( * ) symbols.
The MIN( ) and MAX( ) Aggregates
These evaluates as the minimum value and maximum value (respectively) for
expression among all records, or among records qualified by the optional WHERE
clause and any GROUP specification. For character data, greater than means after in
the ASCII collating sequence, where a> A> 1, and less than means before in the ASCII
sequence, where 1< A< a. For DATETIME or DATE data, greater than means later and
less than means earlier in time. Appendix A lists the ASCII collating sequence.
References
NEED
PAUSE
PRINT
SKIP
SPACE or SPACES
WORDWRAP
PAGENO
LINENO
COLUMN
ASCII
Aggregate Report Functions