How to execute an Oracle Stored Procedure before a subreport 1

[ashishh]

I have a situation. One of the views I am accessing only gets populated if I execute a stored procedure in the same session. How do I execute this in Crystal?

Thanks for your time.

 

[synapsevampire]

You cannot, though you could cheat this by having the View report as a subreport, and the stored procedure execute in the main report and suppress all output in the main report.

You're probably better served to just use a Stored Procedure as the data source.

Crystal is very particular about how Oracle SP's are created as data sources, check:

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ashishh]

Thanks synapsevampire,

Crystal seems to be very strict about calling the stored procedure. Our problem is that we are accessing the database directly from Crystal. If we had a middle tier which passes result-set to Crystal, it would have been easier.

Thanks for you reply. Your efforts are appreciated.
Ashish