Changing Data Sources... 1

[dBjason]

I have (alot) of reports (Crystal 9.2) based on stored procedures in SQL Server (v 8.0). A large percentage of these stored procedures are going to be manipulated, modified, or moved to other databases on the server.

The problem I'm having is that once I redirect the Database Expert to drop the old procedure and point to the new one, all of the datafields on my report vanish. This is incredibly frustrating and time consuming. Most of the time the underlying field names & types are the same. In fact, many times it's the identical procedure just located on a different server. But every time I have to redesign the report by re-adding the fields.

Is there any way around this time-consuming process?

Thanks in advance,

Jason

 

[vidru]

Instead of using the Database Expert, change your data sources by going to Database > Set Datasource Location. Use the lower part of the window to browse to the new procedure, then click the old procedure in the top part of the window, and click the 'Update' button. It will map whichever fields it can between the two.

-dave

 

[dBjason]

Awesome! Thank you!