HP 3000 Manuals HP 3000 Manuals
REPORTING DATA
The reporting commands, LIST and REPORT, display selected information
from the data base(s). QUERY provides several reporting techniques which
enable you to examine the data in the data base without writing a
program. You can report information in three ways:
* Use one command to retrieve data entries for a single report with
automatic formatting.
* Use two commands, one to retrieve data entries which can be used
repeatedly and another to produce a report with automatic formatting.
* Use two commands, one to retrieve data entries which can be used
repeatedly and another to produce a report with your formatting
specifications.
The LIST command combines the functions of locating and reporting. You
can selectively locate entries and print them in a report with automatic
formatting and headings. Data in the formatted report is printed in
columns.
REPORT ALL is a form of the REPORT command. REPORT ALL is similar to the
LIST command in that it automatically formats your report. However,
REPORT ALL reports data entries selected by the last retrieval command.
The formatted report prints one data item name and value per line for all
data items in each retrieved entry.
The REPORT command also reports data entries selected by the last
retrieval command. However, the REPORT command allows you to design your
own report format. Your report can include:
* From 1 to 9 lines of heading information such as a title, column
headings, page numbers, date and time of day. This information can
be repeated at the top of each report page. You can specify blank
lines to be interspersed in the heading as long as the heading does
not exceed one page.
* Sorted data entries with group and total information printed with
entries belonging to the same group. You can accumulate totals,
compute averages, and count entries automatically, or you can use the
thirty QUERY registers to do computations on numeric data item values
and report the results.
* Edited data item values with inserted dollar signs, minus signs,
decimal points, and other ASCII characters.
* Statements which change the output device to the QSLIST device,
define the number of lines per page, request a pause after each page
(in session mode), and suppress the margins which usually appear at
the top and bottom of a page. (For example, information on a line
printer can be printed across the perforation.)
The REPORT command can be stored as a procedure in a Proc-file for
repeated use without re-entering the command. Reporting procedures can
be created which prompt you for desired information when the procedure is
executed. This allows you to use different specifications for the report
each time the procedure is executed.
You can also write your own user-defined procedures in a programming
language which enable your report to perform specialized functions not
provided by QUERY. This feature is intended for use by programmers.
Refer to Appendix F for further discussion.