how can i set the datasource when running the report

[s.fiedeldij]

When running the report we want to set the main datasource dynamically. We want to use one report on multi sql servers. I can't how to change the datasource.

Does anybody know how we can do this?

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Domenico Donofrio]

Hello s.fiedeldij,

as described at the following link you can use user's profile attributes to define a parametrized datasource. When an user runs the report, the Datasource to be used will be defined dynamically accordingly to his attributes

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v60/attributes-data-source-definitions

 

Hope it helps