Category : Paradox DBMS
Archive   : TECH91.ZIP
Filename : TI685.ASC

PRODUCT : Paradox NUMBER : 685
VERSION : 2.0 & up
OS : DOS
DATE : September 11, 1991 PAGE : 1/1

TITLE : Output a Paradox Report on only Part of a Table




To print a subset of records in a table, first extract the
desired records into a separate new Answer table and then copy
the report specification from the queried table to the Answer
table. The following example is based on the Customer table
which is part of the optional installation of Sample tables.

Suppose you want to output a predesigned report on only those in
the Customer table whose name begins with the letter M. The
first step is to do a query on the Customer table. From the main
menu select {Ask} and then give the name of the table. Next,
place selection criteria in the appropriate field(s) and use the
key to Checkmark all fields. All fields must be Checkmarked
or the Customer and Answer tables will not have the same
structure. In this example, type M.. in the Last Name field.
Since .. is the Paradox wild-card symbol, typing M.. in the Last
Name field will give you all of the records with values in the
Last Name field that start with the letter M.

Press the key to perform the query. An Answer table will
result. Answer tables are temporary tables and will be
overwritten when another Answer table is created, when the
directory is changed or when you exit Paradox. If you want to
save an Answer table it must be renamed using {Tools}{Rename}
where the table's current name will be Answer and the new name
should be a name not currently being used.

The next step is to copy the report from the queried table to the
Answer table. Choose {Tools}{Copy}{Report}{DifferentTable}.
Paradox will prompt you for the name of the source table that
contains the report and the number and name of the report you
want to copy. In our example, the source table will be the
Customer table and the report will be 2, Mailing Label Report.
The target table will be Answer and the target report will be 2.
Be sure the structures of the two tables are identical or the
error message will appear "SourceTable and TargetTable do not
have the same Field Names and Field Types." After the report has
been copied from Customer to Answer, using {Report} {Output}
{Printer} on Answer will print only the selected customers.