I am using crystal reports 2008. I am accessing Oracle a stored procedure in my report. Everything works fine but i want remove the connection paramters such as Schema Name, Username and Password that is needed to connect to the database and drive the report based on some configuration file which hold information regarding the connection parameters. In this way , when i migrate the report template to UAT  and PROD,  i dont have to worry abt the changing the connection params through crystal designer.

I am using Business Objects. I checked the options in CMC, I have to select the first option where you sav the password but cannot change the Schema name. I can override the connection if i use the second option but in that case i am getting duplicate records because the report runs twice for some odd reason. This could be because of the OLAP stored proc that is being used by the crystal report.