Stored Procedures

[petersjim]

I have a Crystal report with the data source as a stored procedure (Sybase)
I changed the parameters for the stored procedure.

The report now returns an error (not supported)

I have tried to change the report to have the new paramaters, but it also gives me (not supported)

How can I fix this without re-writing the report?

 

[cjlarue]

You can delete the datasource and then add the stored procedure with the changed parameters. I have seen this problem several times and this is the only work around I have found.

 

[synapsevampire]

Did you try Database->Verify Database?

You might also try Database->Set Location and point to the new SP if that fails.

-k