How to Keep Same Report, Change Data Source

[urwethe]

I have developed a report, pointing to a test database in SQL Server. Now I want to use this report, pointing to another database with live data, identical schema. When I change my data source in Database Expert, I lose all my columns. What's the best way to go about this?

Thanks

 

[hilfy]

You don't say which version of Crystal you're using. In XI, you would use "Set Datasource Location" instead of the Database Expert.

Also, questions like this about Crystal would be better asked in one of the Business Objects: Crystal Reports fora - this particular questions would go in Business Objects: Crystal Reports 2 Data Access. You'll get a more prompt response there.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.