I have recently inherited the maintenance of a couple hundred BO XI reports. They must be set to use a different database. Since they were created with an ODBC data connection, I thought it would just be a matter of changing the properties in the ODBC connection since all the reports use the same ODBC. However, this did not work. It appears that the database name is stored in the report sql query and a database not found error results when a report is executed.
Please tell me there is a way to change the data source without having to open up and edit every single report!!!
I think report is not depend on database connection directly but the universe is. If you are using the DSN name do not change the DSN Name exist in universe. Just change its properties or server name from settings->control panel->Administsiration->data source ODBC and then try to test connection of universe from the Desginer.
There’s no universe involved. The reports use an ODBC data connection. When the ODBC properties (server / database) are changed from Control Panel->Administsiration->Data source ODBC, the report does not run anymore.