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.
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.