Problem Using Crystal Reports With 2 Progress Databases

[Markkbhoy]

I am currently trying to use Crystal Reports with 2 Progress databases, one called Glasgow and one called Mansfield. Both databases have the same architecture. The users access their reports via a web browser using asp to pass the database odbc data source name. If someone opens a report on the Crystal web server for Glasgow's data and then someone else tries to look at Mansfield's data they get Glasgow's data.

I have noticed that Crystal gives an alias to each database ie. pro1 or pro2. The problem seems to be that this alias is dynamic so whichever datasource is accessed first gets the alias of pro1 and the other gets pro2. All the reports are hard coded with the Glasgow datasource and an alias of pro1. I have been assured by Crystal Decisions that passing the odbc at runtime through a URL would work but it doesn't.

Any help in this matter would be appreciated as it is driving me crazy.

Thanks in advance

Mark.