Renaming the stored procedure using Crystal report 9.0

[Former Member]

Hi,

I am using crystal report version 9.0.

Initially i created Stored procedure name called :  SP_Data_Summary_reports.

This SP returns around 55 fields,  and those fields mapped to crystal report.

Now, I going to change the stored procedure as  :  SP_Inline_Data_Summary_reports

what happen as, tried to change the stored procedure in crystal report >> database expert

All fields gone.

Note : both procedure returns fields are same

Any solution to retain the fields even renaming the procedure?

Advance Thanks..!!

[abhilash_kumar · Accepted solution]

Hi Adithya,

Go to Database option on the top > Select Set Datasource Location.

The pane on the top displays the current datasource. Go ahead and create a new connection to the New Stored Procedure from the pane at the bottom.

Next, highlight the SP name on the top pane > also highlight the new SP name from the pane at the bottom > click Update.

Then, go to the Database Expert > Right-click the SP Name > Rename > Type in the new SP name: 'SP_Inline_Data_Summary_reports'

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash,

It's working Good.

Instead of Right click, Select SP name and Press F2 Button> Type in the new SP

Thanks