Include totals in footers to fields in layout collection (2007)

[MSP]

I have a report that includes several groups. The footers all include fields
that are the sum of calculated fields within the detail. When adding totals
to a footer using the grouping, the total becomes part of the "layout" group
for that field. However, the grouping totals only work on fields from the
datasource - not on calculated fields within the detail.

Does anyone know how I can "join" these calculated footer fields to the
layout grouping for the detail field associated with it? For example, I
have a field for "difference" in my detail area. It takes one datasource
field and subtracts it from another. I sum that difference in the footer
areas but can't get it associated with the detail and labels above.

Bill Gates giveth and Bill Gates taketh away.

I hope the question makes sense.

Thanks

 

[Evi]

I have a report that includes several groups. The footers all include fields
that are the sum of calculated fields within the detail. When adding totals
to a footer using the grouping, the total becomes part of the "layout" group
for that field. However, the grouping totals only work on fields from the
datasource - not on calculated fields within the detail.

Does anyone know how I can "join" these calculated footer fields to the
layout grouping for the detail field associated with it? For example, I
have a field for "difference" in my detail area. It takes one datasource
field and subtracts it from another. I sum that difference in the footer
areas but can't get it associated with the detail and labels above.

Bill Gates giveth and Bill Gates taketh away.

I hope the question makes sense.

Thanks

Can you put your calculated fields into the Query on which your report is
based? Then you can add it just like any other field.
Evi