Changing Datasource Information in Stored Procedure

Hi All,

Need your inputs on the following issue:

We have many crystal reports which were developed long time back, these reports retrieves the database logon information from a stored procedure. Now recently the source database was migrated to a new server and all the reports started failing. Now we need to change the server and database information.

In the report under ‘Set datasource location’ it says that the procedure is a repository object. How can i find the procedure name now ? or how can i open that repository object ?

In the properties, Database Type is given as Crystal Queries and Repository object is given as R4404_DATA, how can i edit this repository object ?

I opened business view manager but i cannot see any stored procedure object.

Let me know your inputs, we are using Crystal XI SP3.

Thanks!
Raj


raj342 (BOB member since 2009-05-05)