I have been following this thread with interest. I am interested to know if you can RESET the DBCalc that resides in a breakfooter?
I have a compid (Comp_CountC) associated with my dbcalc count(Control#) and want to reset it based on each customer. Would I be better to use the old way of COUNT for break footers. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, April 30, 2010 4:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Using SUM OF in two page report Doug: Here's what I have in a report in my consulting business. I'm totalling up my travel expenses. One total is adding together the total for tolls and the total for train fare. The control where you want to show your calculated total must be a regular Label object (at least that's what I've found). 1. I have 2 DBCalcs in my report footer. The componentids of them are SumTolls and SumTrain. 2. I have a regular Label object located in the report footer, with a compid of TotalOther. 3. In the "on before generate eep" of the report footer band, I have this code. I know I did a no-no and changed the datatype in the middle of it, so you probably don't want to do that ... SET VAR vtolls TEXT, vtrain TEXT GETPROPERTY sumTolls VALUE vTolls GETPROPERTY sumTrain VALUE vTrain SET VAR vtolls DOUBLE, vtrain DOUBLE SET VAR vsum = (.vtolls + .vtrain) PROPERTY TotalOther CAPTION .vsum RETURN Karen 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).
