How can I Get Crystal Report to Use Stored Procedure As a Source?

[CrystalVis]

Hello All,

I'm using CR version 9 and Oracle 10g. How do I get Crystal Report to use stored procedure as a source for the report? Any help or suggestion is greatly appreciated.

 

[ShortyA]

If your Oracle datasource is setup via ODBC you should be able to see it there. If it is setup but you cannot see ANY stored procedures when using the Database Expert go to File/Options, click on the Database tab and ensure that "Stored Procedures" is ticked under the "Show" group.

Also ensure that you have sufficient permissions to view the StoredProc.

ShortyA