Colin,
HZZ9.99 is what I always use and it works for me under DP 2.6x. When the
value is zero, I get nothing but spaces printed. If I add the ;;B print
modifier, I get nothing at all printed when the value is zero.
I suspect that the value of the field you're trying to print is not actually
zero and is instead something like 0.0001 that only displays rounded to 0.00
when expressed as two decimal places. Unless the field (or RV) value is
actually a true zero, the H format doesn't blank it out.
Try adding an RV with the formula:
round[P1F1;0.01]
and then print the RV rather than the actual field. The RV would be the
value actually rounded down, so 0.0001 would become actual zero and the H
format would work.
Tim Rude
----- Original Message -----
From: "Colin Roberts" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Monday, June 11, 2007 7:43 PM
Subject: [Dataperf] Not printing zero'd decimal fields
> Hi All,
>
> Trying to NOT print zero'd decimal fields - and not getting there :-(
>
> Take a GZZZ.Z9 field and print as HZZZ.Z9 and if field is zero, still get
> .00 printing. Can achieve with ;;E designator but then $48.00 prints as
$48
> Ideally when the dollars are greater than 1, I want the cent value to
print
> even if the cents are zero - just want it to be blank/(print nothing) when
> both the dollars and cents are zero. Used H fields before successfully but
> this must be the first time that I've included a decimal point. Shock -
> horror when it didn't work
> I'm sure there's a work-around - Anyone know of one? ( I'm using DP26X)
> Thanks
>
> Regards
>
> Colin Roberts
>
> _______________________________________________
> Dataperf mailing list
> [email protected]
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
