At 12:39 PM 2/12/2009, Bill Niehaus wrote:
I am trying to generate a label with a sum of "items" (using dbcalc)
located on the label.
I have from 1 to 4 records in a table and I want the sum of the
field "Items" to print on each of the labels. Then I want the
next group of records to get a new sum for the items within that
group.
I am having trouble figuring out if I can set a break point to
force the sum to reset rather than continue to sum for all of
my groups that are printing.
Bill,
By design, the labels in label designer are strictly based on
[Detail] band, thus there is no option to reset any DB Calc
results for the next detail record, as there are no "Breaks"
defined in label designer.
In you specific situation, you may think about designing the
"Columnar Report" to simulate the label with more options, or
use the sum of items and everything else as "Before Generate
Custom EEP" in your existing label.
Let me know how that goes.
Remember, there's more than one way to skin a cat!
Very Best R:egards,
Razzak.
