Ben:  rather than using a dbcalc, you should use a report variable.  
Something like
    vSum      (SUM(items)) FROM yourtable WHERE groupcolumn = groupcolumn

so for each label it will sum the Items columns for the group of that record

Karen

 
> 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.
>   
>  Thanks.
>   
>  Bill Nieha
> 

Reply via email to