Rule Wizard

The Rule Wizard will help you exclude data you don't want on your forms and reports.

For example, imagine you wanted to create a report that only included data between two dates. If the date field was called Invoice->Date and the date range was stored in the variables Answer1 and Answer2, you would do the following:

1. In the Enter the field or variable to compare box enter: Invoice->Date

2. In the list below it select: Is Between.

3. In the first Compare the above field or variable box enter: Answer1

4. In the second box enter: Answer2

5. Click on Finished.

This would then create a rule in CAPITAL Business Script and add it to the current list of rules.

Overview

Enter the field or variable to compare

Enter a database field, dictionary code, variable or value here. Click on the down arrow next to the control to list many of the available choices.

Most of the entries in the comparisons list box are self explanatory. However, note that the choice of "Contains" as a comparison can only be used on character values. The character value of "FRED" is contained in the character value of "FRED SMITH" or "JOHN FRED SMITH". It is useful for matching strings of characters embedded within other strings of characters.

Compare the above field or variable

Enter a database field, dictionary code, variable or value here. Click on the down arrow next to the control to list many of the available choices. If you have selected a comparison operation of "between" or "not between" you must enter both starting and ending values.

Note that values don't have to be database fields or variables. Valid expressions might include numbers, dates or characters. For example, 'John Smith', 1234 and CTOD('01/01/99') may all be valid entries depending on what they are compared against.

You must compare like to like. A date field must be compared against another date field, variable or value. A number field must be compared against another number field, variable or value. A character string must be compared against another character string.

For hints, tips and pointers on constructing acceptable values see: Rule Wizard Guidelines.