Skip to Content

update stored procedure in sap crystal report.

Hi

I have one sap crystal report for warehouse 01 . And there is a stored procedure for warehouse 01

I created another storedprocedure for warehouse 02 . Also I saved as warehouse report as 01

But I want to update stored procedure with WAREHOUSE 02 Procedure. But it removes the field from the report.

Is there any better way ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 19, 2018 at 08:39 PM

    Are you using the "Set Datasource Location" option on the Database menu? If that doesn't work and the stored procedure names are exactly the same, try this:

    1. Open the report in a freshly opened run of Crystal.

    2. Try to run the report, but instead of logging in to 01, log in to 02.

    This may or may not work - Crystal is very picky about how it works with stored procedures and thinks that would work if a report is based on tables or a command may not work with a stored proc.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2018 at 07:22 PM

    Try set data source location and update stored procedures from database to crystal report

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2018 at 07:31 PM

    I tried update stored procedure but it does not update the fields.. I have to write all logic again.

    Add comment
    10|10000 characters needed characters exceeded