Hi Colin,
Fatherhood is going very well... I have cut my official working days to 3
days a week, and look after the boy on Tuesdays and Wednesdays, well.. at
least, that is the theory. In reality I get up very early and go to bed
very late those days...
Glad you picked up my deliberate typo with the 0.09 -> 0.00 :-) That
was to see if you were watching ...
You seem to be getting the output from HZZZ.Z9 that I would expect from
GZZZ.Z9 I presume this is being output on a standard screen or print
report...
It's really curious because one of the things I love about DP is that it is
totally predictable... I have just been going through the nightmare of
upgrades from some very complex Access 2000 applications to Access 2003, and
you would not believe the seemingly minor variations that have taken hours
to fix and workaround... Fortunately the data part seems to all be fine,
its just variations in the interface elements, in code that has worked
flawlessly for 7 years... Whenever DP does something unpredictable it has
been because I screwed up...
Bye
Brian
----- Original Message -----
From: "Colin Roberts" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Tuesday, June 12, 2007 1:34 PM
Subject: Re: [Dataperf] Not printing zero'd decimal fields
Hi Brian,
Yes I've been trying to sort this out for a few hours - here's my info
below - Your output is what I would expect to happen apart from typo (0.09
as 0.09)
Report Variable 155
Field Format: HZZZ.Z9
We wish to advise confirmation of your order for the doors listed below.
Please check specifications and advise URGENTLY if there are any errors or
omissions as production of these doors has been scheduled.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓▓▓▓▓▓ << this
field here
Produces this when field is zero
Dear Sir,
We wish to advise confirmation of your order for the doors listed below.
Please check specifications and advise URGENTLY if there are any errors or
omissions as production of these doors has been scheduled.
.00
Your Order No:408210 Job Name:RASMUSSEN ELECTRICAL 43 <
And variations on this when its not
.........omissions as production of these doors has been scheduled.
DELIVERY IN THE AUCKLAND AREA INCURS A FREIGHT CHARGE OF $ 48.00
Your Order No:408210 Job Name:RASMUSSEN ELECTRICAL 43<
What's different between your system and mine??
BTW How's fatherhood been treating you?
Regards
Colin
----- Original Message -----
From: "Brian Hancock" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Tuesday, 12 June 2007 15:04
Subject: Re: [Dataperf] Not printing zero'd decimal fields
Hi Colin,
Are you sure the HZZ9.Z9 or HZZZ.Z9 doesn't work?
For me with 2.6x the format "HZZ9.Z9" causes the display of :
48.90 as "48.90"
48.09 as "48.09"
48.00 as "48.00"
0.90 as " 0.90"
0.09 as "0.00"
0.00 as " "
0 as " "
Regards
Brian
----- Original Message -----
From: "Colin Roberts" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Tuesday, June 12, 2007 10:43 AM
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
