Join tables from different databases in IReport

Classic Servoy
1

How we can join tables from different databases in IReport to make the report Query for a report?

Thanks,

2

The easiest way to do this would be to use a foundset in iReport (feature of the newest Servoy JasperReports plugin available) where you pass a Servoy Foundset (which can contain data from multiple databases) into the report.

Otherwise, it will most likely depend on the database platform and the driver. It is not a straightforward task in many cases.

Jason

3

Thanks Jason for your reply. I will try it out with the recent release of JasperReport Plug-in.

Thanks.

4

Hi all,

I am facing the same issue too. Have any one tried, How we can pass a Servoy Foundset to the Jasper Report and How the Fields from that foundset can be added to the Report by using IReport?

5

This topic is better suited for the Google Group related to the Jasper Report Plugin.

http://groups.google.com/group/servoy-j … ts-plugin/

Jason

6

jmeunier:
This topic is better suited for the Google Group related to the Jasper Report Plugin.

http://groups.google.com/group/servoy-j … ts-plugin/

Jason

Thanks a lot Jason.