Two Oracle connections and 1 report

[InShadows]

Current configuration. There is change management in place so there is a development application box and acceptance application box as well as an development oracle box and an acceptance oracle box. Unfortunately there is only one Crystal Enterprise box.

I am using URL parameters to call up the reports via ASP and HTML. I am displaying the RPT file. Is it possible to link the one report to the two databases? Those people testing on the development side would see one set of results off of the development oracle machine and the acceptance testing people would see results off of the acceptance oracle machine. I already have the URL commands stating to point to different oracle instances on their respective servers, but it will only work for one instance. The Crystal developer will save it for Acceptance and it will load properly in Acceptance but even though I send the RPT file a new set of Oracle parameters for a connection it will always prompt for a username and password of the Acceptance database.

Is it possible to delete the connection that is saved in the RPT folder and only use the connection I send it via the URL or can there be two connections in the RPT file and it uses the one that is present in the URL, or is this a hopeless case and we will have to save the report twice with a different connection for each? thanx in advance

 

[KellySc]

I am having the same problem. I am new to Crystal Reports and am currently trying to determine if/how to set my database connection information at runtime. I am running the report through a URL. I tried using the following command on the URL (obtained from Crystal documentation), but it did not work:
User-<servername>.<databasename>& Password-
<servername>.<databasename>
My reports are run against multiple Oracle databases (all of the same structure). I don't want to have to save each report multiple times with different connection information. Is there a way to do this?