Complex (or simple?) grouping question

[fabridp]

Hello all.

I'm building a list of invoices report. I grouped this table by the field INVOICE, TAX and in the TAX group footer I made totals.

with JRDataSource lJRDataSource = new JRBeanCollectionDataSource(documents);

---------------------------------------------

INVOICE1

PRICE     TAX

100,00      20%

100,00      20%

          TAX TOTAL OTHER DATA

          20% 200,00   TEXT

200,00      10%

100,00      10%

          TAX TOTAL OTHER DATA

          10% 300,00   TEXT

 

INVOICE2

 

---------------------------------------------

With grouping this is zero-time-cost with iReport.

The layout I need is to have the normal list of invoices without TAX group and a FOOTER INVOICE GROUP table summarizing totals by TAX as shown below:

---------------------------------------------

INVOICE1

PRICE     TAX

100,00      20%

100,00      20%

200,00      10%

100,00      10%

 

          TAX TOTAL OTHER DATA

          20% 200,00   TEXT

          10% 300,00   TEXT

 

INVOICE2

......

 

How can I do? Please help me. Thank's in advance.

Fab

Post Edited by Fabrizio Dal Pozzo at 03/06/09 15:22

[fabridp]

I solved the problem using SQL query for subreport passing a parameter id from main report. I would be happy to solve this problem without using SQL direct DB having just all data.

Any ideas?