Crystal Reports and Stored Procedure

[sim133]

Hi All,
Is it possible to use a stored procedure in Crystal Reports and treat it as a Table or View. I am using Crystal XI or Oracle database. I would really appreciate it, if you can give me some codes if it is possible.
Thanks..

 

[buck149]

yes, of course. all you have to do is go to "option" under file tab, inside the database tab, check store precedures.

 

[sim133]

Thanks Buck149,
I was able to import the stored procedure, The problem I am having is, I don't see the fields in the stored procedure and I am not really sure how I can use the stored procedure in the report.
Thanks.

 

[buck149]

when you checked that "store precedure" in "options", all store precedures will be treated as tables. you can simply establish your database connection and store precedures will be listed under your datasource, click the "plus"sign you will see the name and click the "plus" at the side of the store procedures, you will see all the field you put into your store procedure.

 

[sim133]

Sorry if I am not clear.. I see the plus sign, but when I click on it. It doesn't expand to see the fields in the stored procedure.
Thanks.

 

[buck149]

In this case, you may have to check the output set of your store procedure...

 

[synapsevampire]

Make sure the SP always returns at least an empty row.

-k