thanks for your quick reply.
right, I see what you mean, but I don't want a footer. I want the actual aggregates for each row displayed correctly aligned. The alignment of the footer would be fine, but I want it with the totals of the grouping headers (the totals in the footer are grand totals, that's not what I need).
Is there any way to achieve this?
I tried the sample project on this thread
but it doesn't work well when you have two or more columns grouped (it works fine for one though).
When you have two or more and you start expanding the results you get the totals as footers instead of headers. I'm attaching a screenshot for yor reference.