At 01:38 PM 10/1/2005, David Poole wrote:
But, if I set v30sum to reset on break, then a total is
displayed in the first group break but all subsequent
group breaks are blank (ie v30sum is null).
David,
Place all variable(s) that calculate totals, on Break Footer,
and make sure that they are defined to evaluate each record
in detail line [D] cumulative totals.
Report Designer | Variables | Add/Edit Variables...
Expression Builder ... Calculate On:
In addition, make sure that all related variables are "Reset"
accordingly for related breaks.
Report Designer | Report | Breaks... | Highlight appropriate
break and then click on [Reset Vars] button to check all
related variables to reset.
Take a look at the "SubTotalsAndTotals" report in ConComp
database to understand all details.
Database: ConComp
Report: SubTotalsAndTotals
Related Table: SalesData
Purpose: To demonstrate the use of traditional Sub-Total and
Totals using SUM OF colname technique
Hope that helps!
Very Best R:egards,
Razzak.
