Defining Data Sources per Report Definition

[madler]

I have an application which utilizes multiple data sources. The application is essentially a "Dashboard". There is a core application data store, which contains the data specific to the application, however there could be many other data sources used by the application to display data to the user. Although I know how to create definition files which will look at data contained within the application's own data store, it is impossible to determine ahead of time where these other data stores will be. Is it possible to specifiy a database connection string which is specific to a particular report definition file (e.g. for this report, this database is required, and this query is run on that database to retreive data for the report).

 

Please let me know!

[lucianc]

You can use a custom report property for this:

Code:

<jasperReport ...>
  <property name="db.connection.string" value="..."/>
  ...
</jasperReport>

 

When you fill the report, you would do something like

Code:

[code] JasperReport report = ...; String dbConnectionString = report.getProperty("db.connection.string"«»); Connection connection = createConnection(dbConnectionString); JasperPrint print = JasperFillManager.fillReport(report, params, connection);

 

HTH,

Lucian

[madler]

Let me give it a try. Thanks!