Jasmin01
asked on
Crystal Reports - When field is empty, display a zero
Hi, I have several formula fields that look similar to this:
if {DailySummary.Activity} = 9 then
SUM({DailySummaryPeople.Co ntractDriv erNormalA} )
else 0
Now, when the DailySummary.Activity for the date range entered is not 9, I want there to be a 0 displayed, but I get a blank field instead. Can anyone help me to get this working?
if {DailySummary.Activity} = 9 then
SUM({DailySummaryPeople.Co
else 0
Now, when the DailySummary.Activity for the date range entered is not 9, I want there to be a 0 displayed, but I get a blank field instead. Can anyone help me to get this working?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I checked the DB, and it is of type int, and nulls are allowed. I cannot make chnages to the DB. Is there anything else I can do?
ASKER
Thanks. It worked
Please check data Type of {DailySummary.Activity}
if it is int then check is there any null stored
Dani