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

[Doug Hamilton]

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. > > >