Report Item Format Options
Any meaningful combination of the following options can be applied to any value displayed in a report:
CENTER | The Report Generator is to center the associated item on the current line. Centering is relative to the PAGEWIDTH specified in the REPORT FROM command. The default value for PAGEWIDTH is 80. |
COLUMN n | The Report Generator is to start display of the associated item at character column n. COLUMN cannot be used in conjunction with SPACES. COLUMN 1 is automatic for the first item in each heading or detail line command. |
HEADING ‘text’ | The Report Generator is to use text as the heading for the associated item. (Normally, the heading depends on the source of the item: field names for fields from EntitySets and so on; object names, for variables and constants; spaces, in all other cases.) To turn headings off, specify COLUMN HEADING OFF in the DETAIL LINE command. |
LINE n | Before displaying the associated item, the Report Generator is to skip to line n on the current page. The value of n must be greater than the current line number. LINE cannot be used in conjunction with NEWLINE or OLDLINE. |
MASK ‘mask’ | The Report Generator is to apply the specified mask pattern to the value of the associated item. Masking rules vary for alphanumeric, numeric, and date values. |
NEWLINE [n] | Before displaying the associated item, the Report Generator is to skip n lines. The default value for n is 1. NEWLINE cannot be used in conjunction with LINE or OLDLINE. NEWLINE 1 is automatic for the first item in each heading or detail line command. (Use OLDLINE when overstriking is required.) |
NEWPAGE [n] | Before displaying the associated item, the Report Generator is to skip to the nth page following the current page. The default value for n is 1. |
NOPRINT | The Report Generator is to omit the display of the associated report item. (This option is useful for using a special expression format to initialize a variable, but not print the variable’s value, for example.) |
OLDLINE | Before displaying the associated item, the Report Generator is to return to the start of the current line (“overstrike”). OLDLINE cannot be used in conjunction with NEWLINE or LINE. |
SPACES n | Before displaying the associated item, the Report Generator is to move n character columns to the right. Zero (0) is a valid value for n. SPACES cannot be used in conjunction with COLUMN. |
SPAN | The Report Generator is to display the associated item over one or more lines in a column WIDTH characters wide. When one line is full, display continues on the next line regardless of where the split occurs. |
SUPPRESS | The Report Generator is to omit display of the associated item if its value has not changed since it was last displayed. |
UNDERLINE | The Report Generator is to underline the associated item. |
WIDTH n | The Report Generator is to use n as the output width for the associated item. (Normally, the output width is identical to the defined width of the item or the width of the mask or heading for the item, whichever is greatest. If n is less than the defined width of the item, the value is truncated unless WRAP or SPAN is also specified. |
WRAP | The Report Generator is to display the associated item over one or more lines in a column WIDTH characters wide. An attempt is made to split the item at logical break points (e.g., a blank, a hyphen, an oblique (slash), a comma). |
REPORT FROM | The REPORT FROM command produces a set whose members are used as the source of data values for the report. The various clauses in the REPORT FROM command also specify the overall format of the report and determine if the report is line-oriented or column-oriented. |
REPORT FOOTING | Generates a line-oriented footing at the very end of the report, regardless of whether the report itself is line-oriented or column-oriented. To generate column-oriented footings, use the BREAK (Reports) command with a constant expression. The footing can include individual data values only from the last member of the REPORT FROM set. However, summary data computed over all records in the set (using aggregate functions) can appear in the footing. |
BREAK | Breaks can be organized into the hierarchy: 0, 1, 2, and so on. The higher the level number, the more minor the break. Each change in the value of expression triggers a break at the associated level. The break levels below it in the hierarchy are also triggered; that is, a level 1 break triggers a level 2 break, and a level 3 break, and so on. The report items in the break heading can include individual data values only from the first member of the current group. The report items in the break footing can include individual data values only from the last member of the current group. However, summary data computed over all members of the group can be displayed in the footing. Use aggregate functions. Each time the break level is triggered, headings specified in a corresponding COLUMN BREAK command, DETAIL LINE command, and PAGE HEADING command are also displayed. |
DETAIL LINE | The DETAIL LINE command is executed for every record of the set specified in the REPORT FROM command. The column headings for all reportitems specified in the DETAIL LINE command are displayed, subject to any colheadings specification. Only one detail line is produced for each record of the report set. If more than one DETAIL LINE command is used in a report specification, the DETAIL LINE command that is executed for a particular record in the report set is the first DETAIL LINE without a WHERE clause, or the first DETAIL LINE whose WHERE clause is true for that record. |
PAGE HEADING | The PAGE HEADING command causes a heading to be displayed at the top of every page of a report. It also controls the display of break headings at the top of each report page. Report items in this command can include individual data values only from the first record to be processed on the current report page. |
PAGE FOOTING | the PAGE FOOTING command causes a footing to be displayed at the bottom of every page of a report. Report items in this command can include individual data values only from the last record processed on the current report page; however, summary information computed over all the members on the current report page can be displayed in the footing. |
PAGE RIGHT | The PAGE RIGHT “footing” is placed along the right-hand edge of each page in a column-oriented report. The column of text generated by this command ends in the right-most column of the page. Report items in this command can include individual data values only from the last record processed on the current report page; however, summary information computed over all the members on the current report page (using aggregate functions) can be displayed in the footing. |
PAGE LEFT | The PAGE LEFT command generates a “heading” along the left-hand edge of each page in a column-oriented report. The column of text generated by this command starts in column 1 on the page. Report items in this command can include individual data values only from the first record to be processed on the current report page. |
COLUMN BREAK | The COLUMN BREAK command breaks the body of a column-oriented report into summary groupings. Each time a BREAK command triggers a break at a specified level, the COLUMN BREAK for that level and all levels lower in the hierarchy are triggered. Report items in the COLUMN BREAK heading can include individual values from the first member of the current group. Report items in the COLUMN BREAK footing can include individual values only from the last member of the current group. However, summary data computed over all members of the group can be displayed in the footing. Use aggregate functions. If both the heading and footing clauses are omitted, a column break at the indicated level causes report formatting to recommence at the left-hand side of the page, beneath any previously formatted columns. |
PRINT REPORT | The Zim document specified by name must contain a graphical report previously generated by a REPORT FROM command with the GRAPHIC option. The document can be printed any number of times. If the destination is the printer, the report is printed automaticaly without operator’s intervention. If the destination is the screen, the report can be visualized and then, optionally, printed and/or written to a PDF format file. |
ENDREPORT | The ENDREPORT command is used only in conjunction with a REPORT FROM command. It marks the end of a report. When an ENDREPORT is encountered, the current group of report commands is processed. The resulting report is directed to the current output device. |
There are more options to view:
Insertion of Items / options:
– Report From
– Report Footing
– Break
– Detail Line
– Page Heading
– Page Footing
– Page Right
– Page Left
– Column Break
– Print Report
– EndReport