Grouping and summing in FastReport 3.0

rbasurto

Hi, I'm having this problem:

I have the following structure:

PageHeader
GroupHeader1(<frxDBDataset1."A">+<frxDBDataset1."B">+<frxDBDataset1."C">)
GroupHeader2(<frxDBDataset1."A">+<frxDBDataset1."B">+<frxDBDataset1."C">+<frxDBDataset1."D">
MasterData (ItemNo, Price)
GroupFooter1
GroupFooter2

I'm getting what I want till that step:

A, B, C

D 00001
item1 $xxxx.00 item2 $xxxx.00 item3 $xxxx.00 item4 $xxxx.00

D 00002
item1 $xxxx.00 item2 $xxxx.00 item3 $xxxx.00 item4 $xxxx.00

D 00003
item1 $xxxx.00 item2 $xxxx.00 item3 $xxxx.00 item4 $xxxx.00


But now I need to have a summary like this:

item1 total: $yyyyy.00
item2 total: $yyyyy.00
item3 total: $yyyyy.00
item4 total: $yyyyy.00

---

Total : $ zzzzz.00

And I haven't been able to group such sums.

I have the information on one single query, but couldn't make it work, so I've made several queries and tried to make subreports but I couldn't make them work either.

Do you have any ideas ?

thanks,

Rene