I m using vb6 as frontend, crystal report 9.0 as reporting tool, oracle 8i as backend and odbc as connection interface

Let's say my application is being used in two companies. And for each company i used separate odbc, user and password.(user as schema in oracle). But I have same code and reports for both companies.
I just use setting file to switch between company database which consist of dsn name, user name and password.
The problem is when I develop a report I need to create two separate reports and set the data source location manually in crystal report 9 IDE and place them in separate folders companywise.

How can I use the same report for two different schema when all database structure is same, without having to change the datasource location manually everytime I develop a new one.
How can i do it at run time.

I hope I get an answer this time.

Thankx in advance

No I just pass selection criteria to the report. How are Reports are designed independently of odbc driver and how can data be pushed to the report. When u design the report u need to define the connection, don't u? I think so. So when u design the report using a specific connection, it becomes rigid to that particular connection information. So when connection information is changed in the application, it doesn't work.

Does that mean there is no solution for my problem?
It's so frustrating, I don't get any solution for my problem.
Anyway thanx. At least u took some time for me.

I hope if you can ask others in this forum to help me out.

Thanx a lot.