SAP Knowledge Base Article - Public

1792088 - Crystal Reports hangs while creating the report based on Stored Procedure with parameter


  • Unable to run the reports based on stored procedure.
  • On parameter screen Crystal Report with stored procedure parameter hangs while creating a report.


  • Crystal Reports 2008.
  • Oracle 10g R1 (Stored procedure).
  • Windows 7


Reproducing the Issue

  1. Create a Oracle Stored procedure with parameter.
  2. Create a Crystal report using the Stored procedure as a datasource.

Note: When the parameter screen is prompted it will not proceed but will just stay static


The parameter in Stored procedure was not defined as 'IN' and so the parameter screen didn't proceed.


Define the parameter in the Stored procedure as 'IN'.


Prompt, hangs, , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1


Requirements of Oracle Stored Procedures.pdf