CRXI - 2 DATABASES - 1 REPORT - 1 DSN

[khan007]

I am using: CRXI Designer. SQL Server 2000. Windows 2000.

My questions is, How can I use one CR XI report for two different databases under one database server with a same DSN.

Here is the detail:
Initially I set my DSN "ReportsDSN " to Testdb and created a New connection by using ODBC (RDO) and select Testdb. Now I changed my DSN settings and pointed to Proddb.What I would expect from my prior 8.5 experience is, Report designer should ask me to verify database and once run will display data from production database.My understanding is Reports are DSN dependent rather than any specific database.

But this is not the case in CR XI.
Even i change the DSN settings and pointing to Proddb, Inside the DataSource Location settings the catalog name and database name always remains as Testdb and I won't get any data. just a blank report.

Also noticed, when I opened the Show SQL Query it says:

{Call "testdb.dbo.reportid"........
rather than mentioning like CR 8.5 as {call "dbo.reportid"

The only way it works in PRoddb is if I will create a complete new connection and get rid of testdb connection.


Please advice