Null value populating from left outer join

[Magoo5289]

I have several tabes linked together by a left outer join within crystal. Now for most instances it works wonderfully. However, in the event that a vlaue is not found, it simply displays an empty field. This is quite odd as I am using a summation off of this, and I thought it would be a zero if nothing was found. I have tried many ways to get the value to default to zero but none have worked. Have tried converting to a string and checking for null, doing a count of characters and if zero= 0 but nothing works. Does anyone have any suggestions?

[Malim]

Try this...

Right click in white space on the report, select report > report options. Then, check Convert NULL field value to default.

[Magoo5289]

I actually managed to get it working by using three separate formulas. Your solution is much better. Thanks a lot!

[Malim]

Your welcome.

IMO some things about Crystal Reports are counterintuitive, like the fact that the default to convert NULL value is turned off and you actually have to turn it on. Or, that when you create a drill down report the drilldown section defaults to show and you actually have to set it to hide. I think both of those defaults are backwards!