Group headaches!

[pachjo]

I was under the impression that if you had a group heading and group footer then any totaling performed in the group footer would be on the data returned for each group?

I have a group by date and it lists all the money values etc for that date in the detail and then I do some summing in the group footer.

On a single date the math holds good.

On multiple dates the detail is correctly split by date but the grouping in all of the group footers is the summing of all values across all date/detail groups!

che???

 

[pachjo]

HO!

Rather than create my own function to sum the required sum, the detail section allows you to right click and insert a summary field in the group footer!

The in the group footer if I want that result summed it is there that I create a function to sum the totals