Can I have jasper report with a subreport to a different ms sql database?

[ahmy_1]

I need to make a report with data from two different queries which are from two different ms sql databases is there a way to make this and put it in a server?

[santhosh.devadurga]

Yes, it can be done by using subreports. While adding a sub report it will ask for a connection, instead of selecting "Use same JDBC connection used to fill the master report" select "Use another connection" and provide the expression to your required DB. 

Sample expression : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@"+$F{SERVER}+":"+$F{PORT}+"/"+$F{SERVICE}, $F{USERNAME},$F{PWD})

Hope it will resolve your problem.

[santhosh.devadurga]

Yes, it can be done by using subreports. While adding a sub report it will ask for a connection, instead of selecting "Use same JDBC connection used to fill the master report" select "Use another connection" and provide the expression to your required DB. 

Sample expression : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@"+$F{SERVER}+":"+$F{PORT}+"/"+$F{SERVICE}, $F{USERNAME},$F{PWD})

Hope it will resolve your problem.

[CaPsLoCkEr]

Hello

 

You can also use a subdata set in the same report. This allows you to use another query on another database in the same report. Look at this tutorial:

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/datasets-and-subdatasets