Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 14, 2015 at 09:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Abhilash,

      It's working Good.

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

      Thanks