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.
