Hello there, I think that it would be easier for you to use default adapters instead of java.sql.Drivermanager, moreover it isn't needed to write credentials. To do so, you need to export your data adapter to a XML file, then publish it to jasperReports server. After, that, configure each "Default Data Adapter" property in each subreport, compile them, compile your main report and publish it without datasource connection. (more information in this jaspersoft documentation : https://community.jaspersoft.com/wiki/how-deploy-and-use-data-adapter-tibco-jasperreports-server-v56) Best regards