Doug, I'm talking in general here so I hope it helps. In the report header I would use a DB-Calc to calulate the total for the report and set it to look ahead. Then in the breaks I would place another DB-Calc to calculate the break. In the break, use a GETPROPERTY command to get your 2 totals. Calculate your percentage in the break and display it using a Static Text or a Variable.
Jan -----Original Message----- From: Doug Hamilton <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 30 Apr 2010 14:22:28 -0500 Subject: [RBASE-L] - RE: Using SUM OF in two page report OK, I spoke too soon. I'm still not able to use Report Footer totals in Break point calculations I'm using DBCalcs for summing and have no expressions defined; per Razzak's suggestions, I've predefined all variables and set them to null. Using the SubTotalsAndTotals report as an example, how would I set up that report to use the Grand Total to, let's say, calculate each customer's Sub-Total as a percentage of the Grand Total? Is there an example in RRYB14 of using a report footer total in break point calculations? (I think I went through all the reports and didn't find one but I could easily have missed it). TIA Doug Doug Hamilton wrote: > Perfect timing, Les. I'm trying to do the same thing - I'm using > DBCalc in a report footer to sum miles & gallons, the using those totals > to do some calculations in a break footer above but I couldn't get it > to work - even set for two passes, the totals weren't showing above.. > Then I found the trick after studying the SalesSumAndSubTot report in > RRBYW14. > Place the DBCalcs in the HEADER and use the GETPROPERTY to snag the > values in a Before Generate EEP in the RH. Not sure if that's the > most correct way but its working. > > I was muckin' around with the Pass setting and Lookahead but they're > unnecessary. I changed the Two Pass (Report|PassSetting) to One. I > thought Lookahead was needed but apparently not (in this case). > > I'm gonna keep pluggin' away but wanted to get this out hoping it will > help you. > Doug > > Les Stark wrote: >> I tried calculating it in report footer, page footer, detail, etc, >> .... nothing worked and I cannot use the dbcalc because this variable >> is used as part of another variable in a calculation. > > >
