Text mode – editing the report extraction criteria

After you select the database fields and indicate the characteristics for each, you must provide the values those fields should hold if they are to be selected for printing. Each of the following commands functions to enable you to do just that. Depending on the output you ultimately require, you may not need to use all of these commands together, or indeed, ever.

DEFINE command Indicates that a field must contain a specified variable to be extracted for your report.	FIELD command Indicates you have user-defined fields in your project on which you want to report.
JOIN command Moves between database tables to report on two objects having a certain relationship between them.	PARTIAL command Identifies that information should be extracted even if the conditions defined for extraction are partially met.
WHERE command Specifies the value that database field should have to be included in the extraction file.	SELECT command Specifies the columns for your report.

Note If you do not use the WHERE command to limit the field selection to those with a specific value, all matching fields, regardless of their value, are included. To better manage and control the report output, use the WHERE command to limit what you select from the database.