Hi,
I have a Crystal Report which uses a Stored Procedure as its data source.
The name of the SP is say, dbo.usp_CompanyXYZ_Whse01, and it is found here:
Management Studio -> CompanyXYZ -> Programmability -> Stored Procedures -> dbo.usp_CompanyXYZ_Whse01
I want to rename the SP to the much simpler name: dbo.usp_WH01
I can easily modify the name in Management Studio.
However, I cannot make my CR accept this amended name.
I tried to use Database -> Set Datasource Location ...
But all my attempts resulted in losing all the fields in my report.
What is the correct way to achieve what I want to do without losing any of the fields, which I took a long time to put in the report?
Thanks
Leon Lai