To call REPORT or stored commands containing a REPORT call, various clauses can be specified in addition.
Thus the fields of the header can be set to values by the options PROGNAME, VERSION, MODE and HEADER. For this purpose, an expression (e.g. string or variable) is specified after each keyword and an optional equals sign. The expressions may be truncated to the field lengths that can be represented.
The options, their lengths and values:
Examples:
The final results determined by the REPORT generator for columns of the result table (SUM, AVG, MIN, MAX, COUNT or self-defined arithmetic expressions) can be used further in SQL-PL. To do this, a variable and the corresponding result definition are specified. A result is only non-NULL, if an arbitrary result has been calculated for the specified column when executing REPORT; i.e. if it is defined interactively either when REPORT is called or during the execution. A check whether the specified result is defined in the REPORT statement is not made.
Examples:
Options for the execution of REPORT can also be defined. The option BACKGROUND serves to prepare a result table with the REPORT generator. Output on the screen, however, is suppressed, until another screen output (e.g. a form) has been made (cf. "superimposing forms (background)").
The interactive modification of the SET parameters can be suppressed with SETOFF while REPORT is being executed.
SETLOCAL permits a temporary modification of the SET parameters; i.e. after leaving the REPORT display, the SET parameters are reset to the values before REPORT was called.
If no option is specified for the modification of the SET parameters, every change of the SET parameters has global effects; i.e. it is valid up to the next modification of the SET parameters. The effects of the modifications on the current program must be considered (in particular, when changing the date and time format or the decimal representation).
With the option NOHEADLINE the output can be modified in such a way that the header is kept vacant and the specification of the product name (ADABAS) and of the names of the database and user are suppressed. The specification of this option can be used, e.g., in a master-detail presentation (cf. "master/detail-report") to lay out the detail output more plainly.
Examples:
In multi-DB operation, too, result tables can be prepared with the REPORT generator or stored commands be executed. To do this, the symbolic database name, which has previously been assigned to a user area with the CONNECT statement, is specified after the keyword DBNAME = (cf. "multi-db operation").
Examples:
Examples:
The default key to leave the REPORT display is 
. When calling REPORT, it is possible to specify any keys with any labels to be used to leave the REPORT display. The keys specified
for the call override the keys used by REPORT. The released key can be requested by using $KEY: The keys HELP, UP, and DOWN are mapped to 
, 
, and
as in the case of forms.
Examples:
Syntax:
