Thanks to all,
In the DOS REPORT that has been working for years I Defined the following
new INTEGER variables:
vNoD_ExtPrice = (ExtPrice*100)
Then replaced the ExtPrice field in the Detail with a field for the
variable.
vNoD_InvTotal = (InvTotal*100)
vNoD_AmtPaid = (AmtPaid*100)
vNoD_BalDue = (BalDue*100)
Then replaced the InvTotal, AmtPaid, & BalDue fields in the Pagefooter
with fields for the variables.
It works like a charm.
Thanks again,
Ned
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Mohammed
Sattar
Sent: Sunday, February 23, 2014 10:10 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: NO DECIMAL POINT
Ned
You could print two reports one with the currency format and late another
one without the decimal And fix the variable in the Report itself
Mohammed Sattar
Utah Group of Companies
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Ned Ritchie
Sent: Monday, February 24, 2014 7:49 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: NO DECIMAL POINT
Thanks Buddy,
I think I need to clarify this a little more.
This is for a Point-Of-Sale use.
The data comes from an Invoices TABLE, an InvDetail TABLE, and a Product
TABLE where the columns in question are all CURRENCY.
The Invoice to the customer is driven from a VIEW of these TABLES and needs
to print in CURRENCY format ($123.45).
However a moment later the Red 1500 form is put into the printer and the
same data needs to print without the decimal (12345)
So if we are still on the same page. . .
Where does one modify the application to set the value to text and etc?
Ned
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker
Sent: Sunday, February 23, 2014 4:38 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: NO DECIMAL POINT
Ned
I would set the value to text and then replace the decimal point with
nothing.
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Ned Ritchie
Sent: Sunday, February 23, 2014 7:11 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - NO DECIMAL POINT
I'm still in older DOS and upgrading to Windows. . .
Medicare will be requiring NO DECIMAL POINT on dollar amounts on printed
paper forms.
Example:
123.45 must become 12345
The Report Picture Format in DOS
[>]9999.00 gives 123.45
The following Picture Formats just truncate the cents:
[>]999999
[>]999900
999999
999900
000000
Any suggestions or workarounds?
2nd question:
How would one do it in Windows 7.6?
Thank you,
Ned Ritchie
Judy's Intimate Apparel
