3 Creating Reports

Running a Report Program

Using SORT BY and BREAK ON allow some formatting of the lists. If you want editing capabilities and more complex formatting, however, the REPORT WRITER software can be used.

A subprogram can be written using REPORT WRITER statements and accessing the workfile. You run this subprogram from Query with the RUN command. Syntax is as follows:

RUN "subprogram name [ volume spec ]" RETURN

NOTE: If you have used the DATABASE command to change databases, you must first execute one of the following commands before running a subprogram with the RUN command: ADD, FIND or INFO. These commands open the database, ensuring that the subprogram can access it.

For example, assume you want to run the subprogram REPORT which is located in the directory whose volume label is "PROGRAMS". You type the following:

   RUN "REPORT, PROGRAMS" RETURN

Eloquence Query Manual - 19 DEC 2002