FORM.CONDITIONS

Use FORM.CONDITIONS to enter expressions for conditional formatting. Conditional formatting allows you to create expressions that determine when the formatting variations specified in FORM.DETAIL appear.

You can use conditional formatting to specify detail text for grouped data. The condition is evaluated using data from the first row of the group. If the condition evaluates to true, the detail text for that variation is printed. If the condition evaluates to false, the detail text for that variation is not printed for that group.

FORM.CONDITIONS
                                                             C 
 A            B                                              PASS
 ID   CONDITIONAL EXPRESSION                                 NULLS?
 ---  -----------------------------------------------------  ------
                                                             NO
           *** END ***
 
 1=Help        2=Check     3=End     4=Show        5=Chart       6=Query
 7=Backward    8=Forward   9=       10=Insert     11=Delete     12=Report
 OK, FORM.CONDITIONS is displayed.
 COMMAND ===>                                            SCROLL ===> PAGE
 

 A  ID

Enter a one to three character identifier for the corresponding conditional expression. The identifier is any number from 1 through 999. When appended to the C selection code in the  N  Select Panel Variation? of the FORM.DETAIL panel (page***), it identifies which expression in FORM.CONDITIONS determines whether the detail variation gets formatted.

 B  CONDITIONAL EXPRESSION

Enter a valid REXX expression. The difference between an expression in FORM.CALC and in FORM.CONDITIONS is that a condition results in a value of either true or false. An expression evaluating to 1 is true; an expression evaluating to anything else is assumed to be false. Nonnumeric data, including blanks and nulls, are assumed to be false. You can use any valid global variables in conditional expressions. However, the only QMF form variables you can use in in conditional expressions are &ROW, &DATE, &TIME, and amp;n

For more information, see Using REXX with QMF forms.

 C  PASS NULLS

Enter YES or NO.

YES

Allows you to use the following QMF-provided values to change the default handling in the corresponding situations:

Value

Situation

DSQNULL

Data is null

DSQUNDEF

Data is undefined

DSQOFLOW

Data has numeric overflow

DSQNOINS

Data has no instance

DSQNOREL

Data has no relationship

For example, any database variable that is null (a database null) is replaced with the character string DSQNULL before the expression is passed to REXX for evaluation. You can provide a REXX expression or exec that checks for the string and substitutes 0 (or whatever is appropriate for your purpose) for the database null.

If the expression contains a substitution value that is null, undefined, overflow, has no instance or no relationship, then the entire expression will be set to that value that represents that condition. This expression reduction is performed only on expressions, not comparisons.

If the expression contains more than one substitution value that is null, undefined, overflow, has no instnace or no relationship, then the following order of precedence will be used for expression reduction:

1. Undefined
2. Overflow
3. Null
4. No instance
5. No relationship

If a null value is returned by the REXX expression, you can pass it to your report.

For more information see the:@IF function.

NO

Returns a null for the values listed above. Nothing is passed to REXX for evaluation.