The IF else statement of the formula field in the crystal report cannot be executed normally.

The formula fields are as follows:

If {maintable. botherdoc} = "on" then
Chrw (254)
Else
Chrw (168)

 

Maintable. botherdoc is a string value obtained from the check box through fromconnection. It is "on" When selected, and null when not selected.

The preceding formula field can be executed normally only when the value is on, that is, else will never be executed.

 

Other environments:

The crystal report adopts the push method, and the skeleton uses the dataset delegation. XSD. Only one table is maintable.

 

Solution:

If you change the default value of the maintable. botherdoc field in XSD to "" or other non-null or non-"on" strings, the above formula field works properly.

Note: The default value of the maintable. botherdoc field is changed to <dbnull>

 

That is to say, the default <dbnull> value is all used in this case !!!