Skip to Content
Former Member
Feb 02, 2012 at 06:23 AM

Changing JDBC Datasource Configuration for Report with Sub reports at once


The Env details are as follows

CR Developer

Version RTM

We are using JDBC Connection Datasource for our CR2011 report which contains 30+ sub reports. Each of the sub report uses a JDBC Datasource to connect to Postgres database and Since the JDBC connection string changes on each environment we need to edit each sub report every time we switch environments.

Is there a easy way to accomplish this on all sub reports at one shot?

I am aware that if we use ODBC connection it would be easy since we can just change the DSN config and it will start working. But we are not using ODBC connection since We are seeing that our report (with too many sub reports) crashes when we use ODBC driver for Postgres.

Any help/suggestion would be appreciated.