Reports in QUERY can only be copied to the clipboard as a whole. This can be done either by calling the COPY item from the Edit menu or by use of the report command CLIPBOARD.
The report command CLIPBOARD is quite handy, e.g., for stored commands or batch calls where an automatic clipboard output is to be effected. The syntax for this command is:
Example:
select * from hotel
REPORT
EXCLUDE 1
CLIPBOARD ONLY
END
The option ONLY has the effect that the report is not additionally output on screen and is a useful option, e.g., in batch mode.
The format in which the report is stored in the clipboard depends on the formatting of the report.
If the report can be represented in pure matrix form (i.e., no headers, footers, totals, etc. defined), the data will be output in tabular form, i.e., in RTF format and in text format with tabulators as field separators. The data is output in compressed form; i.e., the values are provided only in their actual length without any fill characters. This form is required, e.g., for Microsoft Word data files or data sources.
If the report cannot be represented in matrix form due to its formatting, it will be output as formatted text as it is shown on screen.
The column headers are always output as well.