CMDBuild Forum

Jasper subreports & external datasource

Old Versions
#1

Hi,

Does anyone have succesfully tried to set a jasper subreport with a datasource different from cmdbuild ?

example : getting organisational data from cmdbuild on the report and querying the ticketing tool  database to extract tickets relative to cmdbuild data ?

Regards,

Olivier

#2

Hi,

Problem solved :
1/ You have to specify a query on the master report even if you have no data to select (ex: select 1)
2/ You have to get the className of the connection on your subreport (ex: on a variable initial expression Class.forName("org.gjt.mm.mysql.Driver")
3/You have to get the Db driver on the tomcat classpath
 
Then, you can specify the subreport connection on the master report.
 
Regards,
Oli
 
Previously Oli wrote:

Hi,

Does anyone have succesfully tried to set a jasper subreport with a datasource different from cmdbuild ?

example : getting organisational data from cmdbuild on the report and querying the ticketing tool  database to extract tickets relative to cmdbuild data ?

Regards,

Olivier