Restricting CE reports to very specific data bases

[new2ce]

We have a 'test eportfolio' and a 'production eportfolio'. We would like to be able to have reports in test eportfolio point to different data bases - some reports to point to data in the test data base and some reports to point to data in the staging data base. Can we do this? How? Is the target data base for reporting 'set' when the report is created?

 

[rhinok]

You can do this a couple of different ways:[ol][li]If you have two separate CE environments simply point the ODBC connection on the Test Server to the Test Database. Point the ODBC connection on the Production Server to the Production Database. This is preferable because you truly have two unique environments. You can also develop to the same ODBC name, which means you won't have to change any settings when you promote your reports to Production.[/li]

[li]If your Test and Production reports resided on the same server then you'll have to have two different ODBC names, each pointing to its respective database. This means that you'll need to point each report to the Production database once its ready to be promoted.[/li][/ol]