connect two databases to make a single report

0

Hi, I'm new to jaspersoft but I'd like to know if you can help me with a little something.
I would like to make a report from two different databases that have a common parameter and that parameter has to be passed for the two queries of those two databases.

thank you.
 

vandro.cbba's picture
Joined: Feb 15 2018 - 1:57pm
Last seen: 7 months 1 week ago

2 Answers:

0

You didn't mention any details about your report but if you can separate section of your report so that each section uses only one database, you can just have sub-reports each with it's own datasource.

hozawa's picture
64038
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 1 month ago
0

Agee with what hozawa indicated. 
You could aswell use a dataset, thus adding an additional dataset. 
Also other elements can be used that could use different datasource than the main report. 
Table element; crosstab element and charts can be assign individual datasources. 

Best would be to use subreport and passover data from main report slq to subreport if you need to combine the first sql query data (main report) with 2nd query sql data (subreport.) 

joseng62's picture
751
Joined: Dec 5 2014 - 2:43am
Last seen: 1 month 3 weeks ago
Feedback
randomness