Subreport grouping subtotals

[herolind]

I have a main report that has two subreports in it. Both of the subreports are grouped and for each group i have produced subtotals. in my main report I want to show the difference between the subtotals produced in subpreport 1 and subreport 2. I don't know if this is possible anyway if anyone can help me please.!

[NTC]

It is possible.

1 approach: In the OnFormat event of section where those subreport exist you would do the math and insert it into an unbound control. Something like:
me.TotalName = me.Subreport1.Report!Total1 - me.Subreport2.Report!Total2

2nd approach: Do the math in a separate query(s) and then make a seperate small subreport of its total - and insert this new subreport into your report.

Hope it helps.