[RBASE-L] - RE: Using SUM OF in two page report

[Doug Hamilton]

Nope, a GETPROPERTY in the Break Footer to get the value of the ReportHeader (or footer) DBCalc only gets the total miles accumed to that breakpoint, not the total for the whole report, which is what I'm trying to get. An _expression_ calced at the Repo Footer didn't work either. Mike, lipstick didn't help. I'm gonna redo the report from scratch & test just one column.  :( Doug p.s. RB 7.6 30111 Doug Hamilton wrote: I think that was it Jan - GETPROPERTY the ReportHeader dbcalc in the breakpoint, not in the Report Header! I was getting in the Header and thought I could use that var in the breakpoints; not true - it has to be gotten every time. And thanks to Tony too.  The totals were being calculated in expressions in the 6.1 version of this report that I'm converting and I want to use the DBCalcs in 7.6 Doug (still testing...) jan johansen wrote: 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 <bugl...@wi.rr.com> To: rbase-l@rbase.com (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. > > >