Sum Total In a SubGroup on Report

[Bucky16]

Hello,

I have a report that displays a customer name and then shows contracts for that customer as a sub-group. For each contract there are multiple material numbers. I would like to show a sum for each contract for a certain group of products. I have tried the DSUM function but I can not get that to work, and I'm not sure if there is a better way to accomplish this other than DSUM. For example, a customer contract may have a number of different TVs that they have purchased as well as a number of DVD players. I would like to show the total sales for TVs for that contract, and I would like to show the total sales for DVDs for that contract. How do I make this grouping within a group based on the product type criteria?

Thanks,

[June7]

What is material number for?

Maybe another group on product type with Sum() calc in that group footer?

Are you only concerned with TVs and DVDs? Maybe an IIf() expression in the contracts group can return summary. Like:

=Sum(IIf([product]="TV", [quantity], 0))

What did you attempt with DSum? Domain aggregates must pull data from table or query objects, does not work by referencing form or report object.