Summary Values in Report Header

[razorking]

I have a report with a list of item numbers and various fields containing related data (inventory value, months onhand, etc). It also contains a field for an item code, DI=discontinued item, N=new item and so on. The N and DI items do not run consecutively on the report because there is another sort option that is more important. I would like to have a snapshot in the report header of the inventory value for all N items and the inventory value for all DI items. Is there a good way to accomplish that?

like this, in the report header:
DI inventory value = $200,000
N inventory value = $750,500

Thanks!

 

[pbaldy]

You could accomplish this with either some DSum() formulas, or a subreport. The subreport would be more flexible.