Group Footer Printing FAR Too Many Times

[dan_thorman]

I have a group that prints out the counts of a number of columns by brand, with the group reset on brand (the sql statement pulling the data groups the counts by brand). I have a group footer that is supposed to print at the bottom (once all the brands have run through) and print out the sums of all the counts (the counts are how many of a given brand have a date in a given range, and the sum is to see how many of every brand have a date in the given range). however, the footer prints after each brand, as opposed to just the last brand. Why?

 

 

I tried putting the totals in the column footer and setting the group footer size to zero, and then it only prints once, but it prints a few inches below the data.

[EuzkoArima]

Hi, try the summary band.

 

HTH