David,
I think you need to create a Before Generate Custom EEP to retrieve the valve from the DBCALC component. If you give the DBCalc a component id, (Cid_vol_design in the code below), you can retrieve this as follows:- (The value is retrieved as text - you then convert it to a real value.) GETPROPERTY cid_vol_design value vtotal_vol_txt SET VARIABLE vtotal_vol = (FLOAT(.vtotal_vol_txt)) Do you calculations in here and then . RETURN (I clear the variables and set them up first but I haven't shown that). I hope that helps. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of David Gideon Sent: Tuesday, 3 February 2015 9:38 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - How do I create a variable to replace a DBcalc in the F0 break in areport? I have a report that subtotals each project's contract amounts and invoiced amounts using DB calc. I need to divide the total for invoices amounts by the total for contract amounts at the project level. According to the help menu, I cannot use the db calc amounts to do this. I need a variable for the sum of the contract amounts and one for the invoice amounts. I am sure there is an easy way to create these variables but I can't get there. I have tried sum(contract) and it gives me an error msg. I tried (contract) and it only gives me the last row's amount. I would appreciate any help you can give me.
