JDBC datasource switch based on query params

[markwilliamson101]

Hi,

Just wondering can one switch or choose the JDBC datasource a report uses to generate data based on query params? 

I have a use case where one single report template is requried, but coud point at several datasources. I would like to be able to do the report without having to make several copies of the same template hardcoded to use a speciific data source. 

Best,

Mark

[elizam]

If this is in the server, you might be able to use attributes:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v630/managing-attributes

However, you can't use report parameters in the query, because the datasource is loaded before parameters.

[hozawa]

If you are programming, you can just dynamically set the datasource to pass to the report. That's what I do.