My report encompasses probably around 9-10 subreports (source=crosstabs). All these crosstabs are generated from the same main table. The reason, just in case someone asks, is that there are like 10 value fields need to be summed individually by year. A Crosstab only allows 1 value field. All the subreports have linked by the CustomerID.

I need to sum some of the subreports together, say 6 out of the 10. Anyone know how to do this? Do I need to create an another subreport just for the sum of the subreports?


Thanks in advance.