Hi,
u have to use a formulas in the property show field
if <<FIELD or FORMULAS>> = 0
then " - "
else totext(<<FIELD or FORMULAS>>)
Quote:
> Hi
> I'm doing a summation for one of the fields that is based on formula
> "instr({STATEMENT.PROD_DESC} , "BOX") > 0" and a reset on the change of
> group.
> However, when none of the records matches the condition, it doesnt show up
> at all? How do I allow CR to show "-" when is 0?
> Using CR 8.5
> Thanks,
> Liming Tsai
Running Total Field