How do I set up restrictions for reports?

Examples of restrictions

Prompts:

A. EQ_MAIN.EQ_EQUIP_NO >= '<PROMPT: ENTER STARTING EQUIPMENT ID>' AND

EQ_MAIN.EQ_EQUIP_NO <= '<PROMPT: ENTER ENDING EQUIPMENT ID>' 

B. EQ_MAIN.EQ_EQUIP_NO = '<PROMPT: ENTER STARTING EQUIPMENT ID>'

Data Restrictions:

A. PLO_MAIN.VALUE_ON_HAND < 0 OR

PLO_MAIN.QTY_ON_ORDER < 0 OR

PLO_MAIN.VALUE_ON_HAND < 0

B. EQ_MAIN.INV_LIST_EXCL_SWITCH = 'N'

Also on the Restrictions tab, you define the one-to-one relationship for a report containing multiple tables. If you want to report on information from two tables, such as EQ_MAIN and FTK_MAIN (Equipment Primary and Fluid/Fuel Information), you will have to 'join' the tables based on a single or multiple set of common information:

FTK_MAIN.EQ_EQUIP_NO = EQ_MAIN.EQ_EQUIP_NO