Changing Data sources for a Crystal 6 report

[tucan]

I have a Report created in Crystal Reports 6. I need to chage the report so it gets the data using a different stored procedure without having to delete and recreate all the field of the report. How can I do that?

Thank you for your help!

 

[MalcolmW]

Database|Set Location, and point it at the new sp. It will then run the new sp, get the data structure, and attempt to map the old structure to the new structure, based on datatype and column name. V6 may (I can't remember for sure) allow you to manually map the column names in the report that it doesn't find matches for. Depending on how closely these match in the two stored procedures, you may have to do some tweaking.