SAP Knowledge Base Article - Public

1358966 - Crystal Reports crashes when report passing parameters using add command statement in sub-report is refreshed or run

Symptom

  • Crystal Reports crashes when report is run or refreshed
  • Error Message appears with following options (see screenshot in attachment below):

"Crystal Reports has stopped working.

Check online for a solution or close program.

Close program"

Reproducing the Issue

1.  Create a function 'GRS_UPDATE_ABC' based on table 'ABC' in Oracle

2.  Create a report based on the function as follows:
     a.  Use ODBC or native Oracle connection to connect to Oracle
     b.  In Database Expert, select table ABC
     c.  Add fields to display: CCN, VAF and user_alpha1
     d. Click finish


3.  Go in Design mode> Insert sub-report
     a.  Name subreport > Click on Report Wizard
     b.  Click 'Add Command' and type the following statement: SELECT GRS_UPDATE_ABC('{?CCN}','?ABC}')
     FROM DUAL
     c.  Click on 'Create' parameter and create 2 parameters: 'VAF' and 'CCN' >Click OK
     d.  Enter Values for VAF and CCN

     e.  Click ok and finish

4.  Insert sub-report in details section
5.  Right-Click > Change subreport links and select ABC.CCN and ABC.VAF
6.  For ABC.CCN, select subreport parameter '?CCN' and for ABC.VAF select parameter '?VAF'
7.  Click ok

8.  Refresh the report.

  • Crystal Reports 2008 SP1
  • Oracle DB Version: 10.2.0.1
  • Oracle Client Version: 10.2.0.1
  • Windows Server 2003

Note:  This report runs fine on Crystal XI Release 2 Service Pack 4.

Cause

This issue has been identified as a bug and is currently under investigation by Product Group under ADAPT01282393.

Resolution

This is issue has been fixed.  Please refer to the Readme file to check the mentioned ADAPT number.

Install Fix Pack 2.1 for Crystal Reports 2008 Service Pack 2.  

Keywords

RCIRAS0546, infoview, your request could not be completed because a failure occurred while the report was being processed. Please contact your system administrator, ADAPT, 01270592 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1

Attachments

CR Crash.docx