adding field values

[Tracey]

Hi
I have a report based on a stored procedure that displays 3 amounts in the detail section.

I have added a formula to add these 3 amounts together for a Total field.

If one of these fields is empty, then the formula result remains empty.

short of trapping each "if isnull(field1) then field2 + field3" combination, which could be a pain in the..., how do i stop this behaviour? surely 5 + 0 + 17 = 22, not 0??

 

[dgillz]

Under file, report options, select the "convert null field values to default" checkbox. This will fix this for this one report only.

To fix this globally, pick the same checkbox under file, options. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Tracey]

oh thanks

I knew there had to be an easy way