multiple datasources in one Chart

[Henry]

Hello,

 

at the moment i create some charts from different data sources (mysql) inside one report. For e.g. i change the data source from subreport to subreport in the same report.

 

So, i have one Report with for e.g. 4 line chart diagrams, each with data from a different data source.

 

What i want now is to use different data sources in one chart. A line chart with data from multiple data sources.

 

My question now, is this possilbe directly in jasperreports?

 

An other solution for this is to use federated mysql tables. I prefer to solve the problem inside the report because i don't want to change our database installation (new database server with federated mysql tables).

 

Regards, Henry

[lucianc]

Henry wrote:

My question now, is this possilbe directly in jasperreports?

 

There is no built-in support for thin in JR.

 

However, you can write a custom data source implementation that collects data from multiple sources and use this data source to fill the report.

 

Regards,

Lucian

[Henry]

Hello Lucian,

 

thank you for your answer.

 

I will do it first with federated mysql tables because at the moment i have nerver work with custom data source.

 

Regards, Henry