Set Datasource of Stored Procedure Problem

[paulmarr]

Hi Everybody

Using Crystal XIR2 and BOEXIR2 and Sybase IQ 12.5 database...

I have a sticky one for you - I have a suite of reports we have developed over our QA database that are all based on Stored Procedures.

I now want to set the location of the reports to run against our Production database. The Prod database has exactly the same stored procedures - both in name and design - but Crystal embeds the datasource details in the report file - thus not allowing me to execute the Production stored proc so I can map the fields - and I have to map the fields becuase of the same reason.

Has anyone ever had any luck in doing this?

It is a show stopper and I would appreciate your input Crystal gurus!!

cheers
paulmarr

 

[paulmarr]

Thanks anyway - I solved it myself.