update stored procedure in sap crystal report.

[former_member197302]

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 ?

[former_member197302]

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

[Abdul]

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

[DellSC]

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