subtotal by group at the end of a report

[frblusso]

Hello

I want to generate a report like in the example jasper.txt attached.

 so I define a group  "mygroup" in Ireport  and the detail band contains the detail of each name.

The problem is to generate AT THE END of the report a summary with SUBtotal for each group .

I defined a  variable Vtotal relied to field value with the parameter "reset type" = group and "reset group" = mygroup

If I put this Vtotal in  Summary band,  the total sum is displayed, but it is not a total for each group .

Is the only solution is to use 2 subreports , one for detail information and one for subtotal information?

Regards

 

Françoise

 

 

 

 

[svenn]

You could create the details in your main report then call a subreport in your summary section that creates the totals by group.

[frblusso]

hello

 

we tried this but the subreport in the summary section is never displayed because the datasource has no data to read. if i put the same subreport with the same parameters and datasource in the detail section the subreport is populated with the good datas.

I have the same problem if i use the last page section to put my subreport.

 

 

 

 

 

 

 

 

[frblusso]

 

the problem is resolved : i create a new JRDatasource populated with the same datas than the main report, and i pass this parameter to the subreport

 

regards

[fabridp]

Im am fabridp and I have the same problem (topic:

Table summarizing totals) with the difference that I have GROUP/SUBGROUP to do "subtotals by subgroup at the footer main grouping". (N subtotal tables)

Can you help me with some detail using JRDatasource approach considering I am quite new with Jasper?

Thanks in advance

Fabri