REPORT/DOCUMENT LAYOUT:

In some cases you may want to create a document or report where 
you have more control over the format than you have in a simple listing. 
Also certain types of record sets -- sales orders, invoices, estimates,
and so forth -- usually need to be presented as separate forms or
documents rather than lines of records on a report.

To accomplish these types of jobs dBworxPE allows you to select fields
from a particular data file and combine them with descriptive text, 
blank lines and other formatting options to create a report/document
layout file.  You can specify how many lines down the report or form 
to start printing a particular field or piece of text and where on that
line you want to print it. Then, using the completed layout file you can 
print all or selected records in your dBworxPE file as individual 
documents or as a formatted report.

The report/document layout file is created by entering a series of "op
codes".  These codes are split into four sections: headings, detail 
lines, subtotals and totals.  The same basic types of op codes are 
found in each of these section.

The "linefeed" op code is used to space down one or more lines 
vertically -- when you enter a linefeed code, you also enter the 
number of line feeds you want in the "Print pos/linefeeds" column.

A "descriptive text" op code tells dBworx to print whatever text you
entered in the "Field desc/text" column, starting at the line position 
you entered in the "Print pos/linefeeds" column.

Similarly, a "data field" code tells dBworxPE to print the current value 
of a given data field starting at the print position you entered in the
"Print pos/linefeeds" column.  You tell dBworx which data field you want
by entering the field description in the "Field desc/text" column (or by 
clicking on the appropriate item in the "Available Fields" box).

A "subsidiary field" code can be used to print embedded subsidiary 
data items in a given record.  For instance, the document layout file 
for the invoice sample included with dBworx uses this op code to print 
the invoice line items which are a part of each invoice record (see the 
"invoice" example).

The "dbloop" op code tells dBworx to loop through all commands from
this point to the "end loop" code.  It's normally used only when you 
have a set of subsidiary data fields (see the help file section on
"Subsidiary Fields").  dBworxPE will go through the set of op codes 
inside the loop, reading sequentially through the subsidiary data 
items and printing the selected fields, until all data items have been 
read and processed (again, you can take a look at the "invoice" 
example to see how to use a loop).

The "deloop" op code is used to mark the end of a print loop.

You can also enter a "Break - Key field" op code, which tells dBworxPE
to check each time it reads a data file record and see if the "Key 
field" (the field whose name is entered under 'Field Desc/text' in the 
"Break - Key field" record) has changed since the previous record.  If 
it has, dBworxPE prints a header line consisting of the name and current 
value of the key field.  For example, in the "times1" sample report 
layout, the key field is "Dept. No." -- assuming that the time sheet file 
is sorted in department number order, then everytime the department 
number changes, dBworxPE will print a line such as:

 Dept. No.: 3

Also, if subtotal op codes have been included in the layout file (as in
the "times1" example), dBworxPE will print subtotals whenever it hits a 
break in department number.