LISTINGS:

NOTE:
The difference between a "listing" and a "report" in dBworxPE has
to do with the amount of formating.  A listing is simpler in format, 
consisting of data fields, field descriptions and totals.  A report 
can include items such as additional descriptive text, page heading
information, sub-total headings and so forth.  If you need more than
a simple listing, see the help file section on "Reports".

To create a new listing template or load an existing one and print a
listing using that template, start by clicking on "Setup/Run Listing"
under the "Reports" menu.  Next, select which format you want -- 
multi-column (format 1) or single column (format 2).  NOTE: if you're
going to load an existing listing template, it doesn't matter which
format you select at this point; dBworxPE will take the format code 
from the layout itself.

After the listing setup screen appears, you can select to load an
existing template or you can create a new one.  To create a new
listing, enter the listing title, then click on whichever fields in
the current file (displayed in the "Available fields" box) that you want
to include in your listing.  As you select a given field, that field is
automatically added to the box on the right side of the screen.

NOTE: fields should be added in the order you want them to appear  
           on the listing (You should also have sorted the file in this
           same order before setting up to run the listing).

If you select a field by mistake, you can click on that field in the
"Selected for listing" box in order to remove it.

dBworxPE will automatically calculate and print overall totals for any
numeric fields that have a "T" under "Total Flag" in the field
definition.  If you want to print sub-totals whenever there's a change
in the value of a particular field (e.g., sub-totaling an inventory
report by store), you can right-click on the field you want ("Store
Number" in this case) in the "Available Fields" box, then click the
"Sub-total" button. 

To create a listing that's summarized by a certain field, right-click
on that field in the "Available Fields" box, then click the "Summarize"
button.  For example, let's say you have a set of invoice records that
contain store number, invoice number, product number and quantity 
sold and you want to produce a listing that shows quantity sold
summarized by product for each store.
 
First, sort the records by store and product number. Then create a
layout selecting store, product number and quantity sold as fields to
print.  And finally, right-click on the product number field and click the
"Summarize" button.  Once you've finished your set-up, you can click
"Save listing" and store the layout as a dBworx template if you intend
to use the listing again.  

After you've created your new listing setup or loaded an existing one,
just click on "Run listing" to build your printout from the current 
dBworxPE file. Once the listing is generated dBworx will give you a
chance to save it to file before printing; then it will ask if you're ready
to print -- if you say no, the system will then give you an additonal
option to export the listing to WordPad in order to view, edit or print it.