|
|
|
|
|
Define a print column.
The PRINT command determines what data is printed, using what format and in what order.
General format
print field_name -
[,BY_YEAR, BY_MONTH or BY_DAY] -
[,NEW_PAGE_ON_CHANGE] -
[,EDIT_STRING = "edit_string"] -
[,IF field_name = value] -
[,NODETAIL] -
[,SORT = ASCENDING or DESCENDING] -
[,special_word] -
[,TITLE = "string/string/..."] -
[,TOTAL = (break_field,break_field,...)] -
Examples
print size,nodetail,sort,total=directory
Qualifiers
by_day
The BY_DAY option will round off the field value to the nearest day. This is useful if the data is to be grouped by day. This can only be used with fields of type QD.
by_month
The BY_MONTH option will round off the field value to the nearest month. This is useful if the data is to be grouped by month. This can only be used with fields of type QD.
by_year
The BY_YEAR option will round off the field value to the nearest year. This is useful if the data is to be grouped by year. This can only be used with fields of type QD. Edit_string supplies the format to print the field value in. Please refer to the section describing all the various elements of an edit string.
field_name
The field name must be the first word in the command. The field names are different for each database used in generating a report. Please refer to the Field Table for the particular database. This name can be prompted for.
if field_name = field_value
The IF option allows a value in one field only to be printed in the specified column if the value in another field has a certain value. The value specification can contain wildcards. Only type T fields can be referenced in this option.
new_page_on_change
This option will force a new page to be started whenever the data in this field changes.
nodetail
Nodetail suppresses all detail lines for that group. This is used in conjunction with IF and TOTAL to cause only group totals to printed, with no detail information from each entry.
special_word
Special options are available when extracting data from certain databases. Please refer to the description of the particular database.
sort [= ASCENDING (D) or DESCENDING]
The sort option will cause the specified column to be sorted.
title = "string/string/..."
Title establishes the column heading for this print column. The default heading is just the field name. Several lines can be defined for each heading. Each line is separated by a "/" slash. The title string can be prompted for.
total = (break_field,break_field,...)
Total sets up group totals. Only break fields that have been sorted can be totalled. The break fields mentioned in this option can only be of type T or QD. This option is only meaningful for totalling numerical fields.