Re: How to get Crystal Reports to access stored procedure

Andy Hardy wrote:

> I've been asked to get Crystal Reports to generate a report based on an
> Oracle stored procedure?
>
> I kind of expect that the stored procedure will have to return a cursor
> reference in the same way as I would with OO4O. However, the Crystal
> documentation is very vague on what it expects to see.

I've used Crystal 5.0 Pro with stored procedures and Sybase SQL Server. I just created the procedures to return a result set just like any normal query would. No cursors involved.

--

Robert Claeson
Robert C Produktion AB - Box 20055 - S-104 60 Stockholm - Sweden
Tel +46 8 462 30 05 - +46 708 12 41 00
Fax +46 8 462 30 01 - +46 708 13 42 00
E-mail robert_at_rc-produktion.se