How to Create a Report + JDBC PostgreSQL with SubReport + JDBC SQLServer

[fabi_1309]

Hello,

Please some kindness soul can help me?

I need to create a master report with a PostgreSQL jdbc database connection with a subreport thats use a SQLServer jdbc database connection.

The Java returns that PostgreSQL from the Master Report doesn't recognize the Quey from the subreport (that's SQLServer). This is the "C0052S" in the log attached.

Thank you in advance,

Fabi

[fabi_1309]

Hi,

I've tried to use this tips, but I don't have the iReport. 

https://community.jaspersoft.com/wiki/how-use-two-different-connections-databases-ireport

I´m using: Jasper Studio 6.11.0  and  Server  6.2.0

Tnks,

Fabi