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

[Doug Hamilton]

"you may pre-define the (SUM(ColName)) INTO a variable to display anywhere you wish. This could be uses as "On Before Generate" action at the Report level itself." That works perfectly, Razzak.  Thank you. More comments below. Thanks again. Doug A. Razzak Memon wrote: Doug, First, R:BASE 7.6 for Windows (Build: 7.6.8.30331) is the currently available version. http://www.rupdates.com/rbg76/ oops....  Done, thank you.  :) FWIW, in order of sequence, all Break Footer(s) are calculated prior to the last portion of the report, the Report Footer. An interim break footer will not calculate the totals for the whole report. But I thought that's what the Two Pass setting was for.  "Two Pass setting is important when displaying summary calculations in Report Header band, summary calculations in the Page Header band and Break Footer calculations in the Break Header band." I extrapolated from that and thought I could go through on the first pass and get the summary calculations, save them in a variable and then use those vars in BreakPoints on the second pass.  Sort of like finding the total number of pages on the first pass so you can print "Page x of nn" on the second pass. What I understand now is that summary calculations are for display only and can't be GETPROPERTY'd into vars for further calculations. Or, the other option (I thought) was to place a Sum(colname) DBCalc in the Report Header and use the Lookahead option to get a report total.  Then save that total in a variable for use in the Breaks.  I couldn't get that to work either. However, if you know the WHERE Clause used for the report, you may pre-define the (SUM(ColName)) INTO a variable to display anywhere you wish. This could be uses as "On Before Generate" action at the Report level itself. Yes, I have an &vWheClause and did SELECT INTO the vars in a Before Generate EEP - works great and the report is done (almost - cosmetic stuff). Thank you. I also noticed that you never mentioned the placement of EEP for GETPROPERTY command. Is the GETPROPERTY command used "before" or "after" the band is generated? Each band in a report includes two options, "Before Generate" and "After Generate". I tried 'em all when trying to capture the totals: Before & After on Report Headers and Footers, but it's not an issue now that I'm using the SELECT INTO in the Before Generate Report EEP. As for the Break Point, the GETPROPERTY commands and related calculations are in the After Generate Break Footer 0. Interestingly, it didn't make any difference if they were in the Before or After Generate. Hope that gives you some blue's clues ... Yes it does. Blues cleared thanks to your Clues. Very Best R:egards, Razzak.