Query data from another connection in a sub report

[jholden699]

I'm not sure if this belongs here or in an iReport/Jasper forum but since this will ultimately be on JasperServer this should work...

I would like to make a report that queries from one database connection, then uses information from that query as a parameter to a subreport querying off of a different connection.  The sub report runs fine independently, but when added to the parent report, it doesn't do anything at all.  I think it's because it's not getting the right connection.

Is there any way to accomplish this?

[jholden699]

Does anyone have any input on this? It seems like it cannot actually be done?

[clhubert]

About a quarter of the way into this video.... It shows you how to make a subreport .

http://ireport-tutorial.blogspot.com/2008/10/ireport-subreport.html

At a high level.... You will want to pass in the the fields into the subreport as parameters.     When you define a sub report you define the parameters you're passing into it (if any).

Hope this helps.

[mkusterm]

I have opened a different connection on a subreport by

selecting "use Connection Expression" on the subreport tab

and new DataSource(user,pw, url...).getConnection()

 

m