Skip to Content
0
Nov 16, 2012 at 09:56 AM

My CR uses a Stored Procedure. How to rename the SP?

51 Views

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