Crystal Reports IsNull function

[GeoffRogers]

I have a field in a crystal report called address3. When it doesnt contain data i want to be able to move the next fields up in the report as though the field wasnt there. Do i use the ISNull function? If so could a friend show me a piece of code I could adapt to do this.
Thanks

GeoffRogers

 

[beaudop]

If the field is something you can put in its own details section, you can set the format for that section to "suppress if blank." That's the easiest way.

 

[nutcase]

Or you could set up a formula field such as "Addr_Line" then use the following code:

if isnull({address3}) then {address4}
else {address3}

this would put the contents of address4 into Addr_Line if addess3 was null, otherwise it would put the contents of address3 into Addr_Line. Then just put Addr_Line on your report.