Conditional Running Total not Reporting 0.00

[CindyN]

Using CR 8.5, I have a report with a calltype field and a cost field. I need to summarize this info for total cost by calltype. I created a conditional running total, which works pretty well except:

Some of the entries appear as 0.00 and others are blank. I need to have 0.00 appear when there are no cost entries for the calltype.

Can I force a 0.00 using a conditional running total?

My x-2 formula is '{CREPORT.CALLTYPE} = 1' (or 2).

 

[atran]

Using this condition in SQL statement.

 

[kenhamady]

One short cut you could try is to go to:

File - Report Options

and check off the first checkmark (Convert Null field to default).

This might solve it. Although, it may have unintended consequences if you use the IsNull function in other places. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[CindyN]

This option is not available (greyed out) on my report. Any other suggestions?

 

[Varco]

I have worked around this by using the following in a formula where you want to display the result of the Running Total:

if IsNull({#RunTotal}) then
0
else
#RunTotal Jim Varco
Varco Consulting
varco@compuserve.com