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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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

Cause

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

Resolution

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

Keywords

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

Product

Crystal Reports 2008 V1

Attachments

Requirements of Oracle Stored Procedures.pdf