Razzak, thanks. I'll give that a go.
However, I can't access that sample app'.
Also, I am having fun with this ability to do conditional formatting in
reports. As it's nearing the end of our FY, there are a number of data
"clean-up" issues. I have designed a fairly comprehensive Q/A
("Police", "Exception") report, but adding this WHITE on BLACK
presentation for suspect data is really cool. In fact, it's cool enough
that I'm contemplating color; it's just that this report is quite long
...
Anyway, would like to see that sample app' if possible.
Thanks much,
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.
Razzak Memon
Sent: Friday, June 20, 2008 4:22pm 16:22
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: How to GETPROPERTY Value of CURRENCY Field
inReport Break Footer?
At 02:19 PM 6/20/2008, you wrote:
>I have been able to do this w/o problem for some TEXT-type fields
>on the report, but I'm not sure which other control to look at as
>a guide to getting the correct "value" property for this CURRENCY
>-type field. Could it be the TEXTVALUE property, as in a DB EDIT
>control or is it something else?
Steve,
You need to use the GETPROPERTY <DBLabelCompID> VALUE varname
Here' how:
01. Use the GETPROPERTY <CompID> VALUE TextVarDataType to get the
value of assigned DB label
02. Convert the TextVarDataType to CurrencyDataType
03. Now do what you need to do with the Currency Value
Example:
CLEAR VARIABLE vCustInvoiceTxt, vCustInvoiceTot
SET VARIABLE vCustInvoiceTxt TEXT = NULL
SET VARIABLE vCustInvoiceTot CURRENCY = 00.00
GETPROPERTY CustomerInvoiceTotal VALUE vCustInvoiceTxt
SET VARIABLE vCustInvoiceTot = (FLOAT(.vCustInvoiceTxt))
That should give you the results you need.
A sample application to demonstrate the use of such feature is
also available on 2008 SAT Sample Applications.
2008 SAT Sample Applications: http://www.rupdates.com/SAT2008/
Folder: \CapturingDBCalcResultsAsVariablesInReports
Database: DBCalc
Report: SalesAnalysis (Sales Analysis by Customer)
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
