How to execute stored procedure parameter in crystal report?

crystal-reports-xi
Alone picture Alone · Jan 16, 2014 · Viewed 12.5k times · Source

I am use crystal report - 11 I want execute stored procedure with parameter using add command. I am tried below code-

exec sf02.gen_statement_data('MS0001','1-Nov-2013','15-Nov-2013')

but it fetch error invalid SQL statement. so please give me a solution for that.

Answer

A B picture A B · Jan 16, 2014

To call Stored Procedure from crystal report,

Set data source of report to Stored Procedure (DataBase Expert Wizard). That procedure must met thses requirement

1- You must create a package that defines the REF CURSOR (type of field that will be retrieved).

2- The procedure must have a parameter that is a REF CURSOR type. This is because CR uses this parameter to access and define the result set that the stored procedure returns.

3- The REF CURSOR parameter must be defined as IN OUT (read/write mode).

4- Parameters can only be input (IN) parameters. CR is not designed to work with OUT parameters.

5- The REF CURSOR variable must be opened and assigned its query within the procedure.

6- The stored procedure can only return one record set. The structure of this record set must not change, based on parameters.

7- The stored procedure cannot call another stored procedure.

Related questions

Crystal reports suppression formula with multiple OR operators not working

I am trying to add a very simple suppression formula to my Crystal Report (XI) field but it is not working as expected. I would like a text box to be visible if certain conditions are met, otherwise suppress. With …

Read More
The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception

I'm working on a project and have run into an issue. When I run my code I get this error message: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception The title of the message is "TypeInitializerException was unhandled". …

Read More
Crystal Report : formula for Splitting string on / and concatenating it with other string

I have string coming in this format WORVS/000017/0005. I want to split the string on /. I want only 000017 from this string and further I had another column to which it has to be concatenated. I need a formula for same.

Read More