Replacing SQL querey with a Stored Procedure
Posted on 2003-11-05
I have a Crystal Report, which has an embedded SQL querey, (to fetch data for the report) I just want to remove that SQL querey and make my report fetch the data using a Stored Procedure instead.
Don't know how to do that! :)
If I try to remove the Tables from the report first, the report designer also start removing the fields from the report. I don't want to completely re-do the whole report.
Is there I way that I can just replace the SQL querey with the Stored Procedure name without disturbing the current layout / fields-positions etc from the report.
An urgent reply will be highly appreciated.