Running Total Showing blank when 0

[BiggerD]

Can anyone tell me why when I run a report in Crystal 7.5 a running total shows 0 when it should show 0 but when I run the same report in Crystal 8.5 dev it shows a blank field when 0 but all other values works fine. all format fields and other configuration seems to say show 0 when 0. ? ? ?

 

[dgillz]

from the file menu, select options, the n the reporting tab and make sure the "convert null field value to defualt" is selected. Then run your report again and let me know if that fixes it. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[BiggerD]

My thanks for your reply I have tried what you suggested and it has not had any effect.

 

[Madawc]

Check the field format, number customise. There is a field called Suppress if Zero which might be set. Madawc Williams
East Anglia
Great Britain

 

[BiggerD]

Already tried that but double checked just in case. no joy

 

[chelseatech]

If the running total gets no data, it is NULL, rather than zero.

Add this formula to your report...
If isNULL({what youa re checking}) then "NULL value found"

To confirm. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm