I'm using formula by grouping records in my report like this:
field1 + field2 + field3
But when a field inside the formula is null (for example field2
) Crystal Reports not groups records properly; So I have to insert in the formula a condition like:
field1 + (if isnull(field2) then "" else field2) + field3
But there is a method to tell to Crystal Reports that when he find a null value it must return a default value that I have set?
Or is there a method to 'initialize' fields so that recognizes a null field as ""?
Use this:
or
File | Report Options
.Convert NULL field value to default
" checkbox.If this box is checked,
NULL
is returned as a special "automagical"DEFAULT
value. This typically will convertNULL
to zero in formulas and running totals.Folks who are using newer versions of Crystal Reports will notice an additional checkbox in Report Options called "
Convert Other NULL Values to Default
".This checkbox refers to the NULLs being returned by objects other than database rows (i.e. formulas and running totals). Typically a combination of both of these checkboxes is required to properly fix a zero totaling problem. (Depending on back-end database and usage)[1]