Month and Year Grouping

[dr.dexter]

Hi,

I'm new to JasperSoft reports, trying to speed up my report.

At the moment I have a report with a subreport

Main Report  Requests by month

Monat / Jahr      Product        Count [Abrufe]       SUM [Pixel]

11 / 2014            ProductA       1                                140.537
11 / 2014            ProductB       27                              24.729.306
11 / 2014            ProductC       39                             42.414.047
11 / 2014            ProductD       3                                3.274.020
10 / 2014            ProductA        281                           319.353.787
10 / 2014            ProducB         62                             72.929.606

...

Sub Report Requests by year (Variable User, startdate enddate passed)

Jahr                     Product           Count [Abrufe]     SUM [Pixel]

2014                    ProductA         7.891                       10.183.925.905
2014                    ProductB         515                           578.575.264
2014                    ProductC         781                          661.364.995
2014                    ProductD         275                          412.680.267

So it's working, but due to the large DB this takes 15 minutes for the first request, and 15 minutes for the subrequest.

Is it possible to speed things up, and make an aggregation of the first result? Or is my concept of adding a subreport wrong? Could I aggregate by product  for the year in the footer of the first report?

Thx for your help

dex

 

[plambert_1]

Can you provide further information ? 

- How long dures the query execution process for both ?
- Why do you need a subreport ? Cant you have both Month and year in one query and then use groups of jasperreports?
- In which banc did you put your subreport?
 

[dr.dexter]

Hi,

thanks for your help. The report ist from a former colleague and I have no experience in using Report software.

He din't use the groups of jasperrerports, did the grouping only wiht SQL.

I deleted the subreport, changed order by  (-> product) and use grouping by product. So i get the sum for every product, that's better than by year.

Thx!