Hi, Maybe I am not fully understand your problem, but here is a way to create a grand total in a report and use it in a break
Variable: = GrandTotal Expression: = sum of miles Table: = <name of table in which the column 'miles' exists> Level: RH = Report header Make sure that the Report Header is used by the report (it could be empty, but it must be used in the report, otherwise the calculation is not being performed). Now you use the GrandTotal in your calculations. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: vrijdag 30 april 2010 21:22 To: RBASE-L Mailing List 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. > > >
