home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI539.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
2KB
|
67 lines
PRODUCT : PARADOX NUMBER : 539
VERSION : 3.00 OR GREATER
OS : DOS
DATE : September 11, 1991 PAGE : 1/1
TITLE : VARIABLES IN REPORTS
The Lookup feature, in version 3.00 Paradox Reports, provides a
clever method of placing variables in Reports. Please refer to
pages 89 through 91 of the Presenting Data manual for a complete
description of the Lookup feature within Reports. The following
information is based upon your knowledge of the information
presented in the manual.
The steps to accomplish the placement of variables with a Report
is as follows:
1. Create a table called VARIABLE with the following fields:
Variable Link A1* *key field
Variable Contents A80
Your own Reporting Table should be restructured to have a
field of type A1.
2. In Report Design, or Change, mode you press [F10] then
choose Field\Lookup\Link\Linked. Specify VARIABLE as your
Lookup table's name.
Link the [VARIABLE LINK] field from the VARIABLE table to
the new A1 type field in your reporting table.
The A1 type field of both tables must always remain blank,
to ensure the link.
3. Within the reporting table, in order to place the variable
information, place the field [Variable->Variable Contents]
wherever it is needed. Make sure your variable
information has been placed in the [Variable Contents]
field.
4. At output time, the reporting table will look for a match
to the blank value in the linked field. This match will
be the 1st and only record in the VARIABLE table, causing
the variable to be placed on the report.