Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Renaming the stored procedure using Crystal report 9.0

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..!!

Tags:
Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question