Set custom datasource at runtime using parameter

[slingky]

Hi guys!

I have JasperServer 6.3

I usually publish my reports on it and link a data source from the repository.

I would like to be able to set the datasource at runtime using an input control parameter.

For example, in repository, I have these data sources

DataSourceA -> point to server A
DataSourceB -> point to server B

DB structure is identical on both server but data is different.

I read a lot of threads but didn't get how to implement this.

Could you help me please ?

Thanks,
Maxime

 

[slingky]

Is there a way to do that without esproc ?