what we use for NULL in crysatl rep 2

[davi123]

what we use for NULL in crysatl reports.

In my table the column c1 is number and one record has a value NULL for this column.

I will check if c1 value is NULL then use font color black, in changing highlight option.

what's the syntax for null in crystal reports.

 

[MJRBIM]

IsNull(field)

and

Not IsNull(field)

 

[pgtek]

hi

heres the formula

@Null

if
isnull({your_field})
then
Red
else
not isnull({your_field})
then
blue

 

[lbass]

You cannot format a null field --since it isn't there. If you want to highlight the space to emphasize the null field, then you need to insert the field into a text box and then you can format that to a different color by going to format text->border->background->x+2 and entering:

if isnull({table.field}) then cryellow else crwhite

If you just want to change the font of OTHER fields based on this null value, then you can use the above formula in the font formula section, changing the color to black.

-LB

 

[Madawc]

Be sure to test for Null before testing for anything else. Otherwise Crystal will stop when it finds a Null, i.e. if isnull(a) then "Null" else if a = 1 then "one" else "other" would work, but if a = 1 then "one" else if isnull(a) then "Null" else "other" would return nothing.

Madawc Williams
East Anglia, Great Britain