Renaming the stored procedure using Crystal report 9.0
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?
Abhilash Kumar replied
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'