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.
Posted on March 6, 2017 at 7:27am
If this is in the server, you might be able to use attributes:
However, you can't use report parameters in the query, because the datasource is loaded before parameters.
Posted on March 6, 2017 at 2:26pm
If you are programming, you can just dynamically set the datasource to pass to the report. That's what I do.