Report with Multiple connections

[2005 IR Help]

By: Bj - bjkhan

Report with Multiple connections

2004-10-14 07:00

Hi,

 

I have to create a report with 2 queries on 2 databases (Linux/Oracle and As400/DB2) through jdbc.

How can I handle this ?

Actually I'm generating my report by calling the

JasperFillManager.fillReport(japser file,params,connection); function with only one query.

 

Best regards,

 

Bj

 

 

 

 

By: Bj - bjkhan

RE: Report with Multiple connections

2004-10-14 08:08

RE,

I found an answer from Teodor saying this

 

"Hi,

 

You will probably use subreports.

This is because you can supply a different

Connection object to each subreport, which can

be different from the master report Connection itself.

 

Since it is you who create the connections, you

can connect to any DB you might want to.

 

I hope this helps.

Teodor "

 

How can I set different connections to my report ?

I have one master and one detail but I didn't find out how to set 1st connection to master an 2nd top detail.

 

Any help is welcome !

 

Bj