Mark,
Put a component id on your dbcalc object Grab the value in a text variable Convert the value into currency Do your next calculation Put the result in another variable or as Razzak likes to do, make a plain text out of it by assigning the variable to the caption -- Before Generate EEP -- Related to Capturing DBCalc Results as Variables CLEAR VARIABLE vCustInvoiceTxt, vCustInvoiceTot SET VARIABLE vCustInvoiceTxt TEXT = NULL SET VARIABLE vCustInvoiceTot CURRENCY = 00.00 GETPROPERTY CustomerInvoiceTotal VALUE vCustInvoiceTxt SET VARIABLE vCustInvoiceTot = (FLOAT(.vCustInvoiceTxt)) SET VAR vPercentage = (ROUND(((.vCustInvoiceTot/.vCoverPageTot)*100),2)) PROPERTY CustomerPercent CAPTION .vPercentage _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 9:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: V8 -DBCALC as Variable I might have missed this one on the list. Would anyone be able to tell me how to capture a DbCalc in a report in to a variable for the purpose of using the result in other calculations in the report? Thanks Mark _____ Delicious ideas to please the pickiest eaters. Watch <http://living.aol.com/video/how-to-please-your-picky-eater/rachel-campos-du ffy/2050827?NCID=aolcmp00300000002598> the video on AOL Living.
