DO we really need to write a seperate cursor to access a stored proced

[aamkumar]

Hi

I have never used a stored procedure in Crystal reports but tried dropping one through the database expert. I have seen that as soon as I drop it in I get a prompt for parameters and parameter fields are created in field explorer because of stored procedure.
But is it must to write a cursor seperately to access a stored procedure in crystal or it is needed in access certain type of stored procedure.
If I can get any link to work with stored procedures in Crystal I will really appreciate.

Thanks

 

[Ridyen]

If you use the database expert to utilize a stored procedure it will (as you stated) prompt you for parameteres if the stored procedure is expecting them. You can either enter valid parameters or accept the default/null values. It should work just fine. Of course when you run the report you will need to enter valid parameters.

I don't see that a stored procedure containing cursors has any impact. It should work as well.