1456963 - Error; Catastrophic failure... when exporting a Crystal Report using RAS SDK for .NET

SAP Knowledge Base Article - Public

1456963 - Error; Catastrophic failure... when exporting a Crystal Report using RAS SDK for .NET

Symptom

  • Exporting a report using Report Application Server SDK for .NET
  • Report connecting to parameterized Stored Procedure on MS SQL Server 2008
  • Code used to pass in the parameter;
ReportClientDocument.DataDefController.ParameterFieldController.SetCurrentValue("", parameter.Name, this.logId);
  • The parameter of the Stored Procedure Parameter is of the type integer
  • Full error;
Error; Catastrophic failure  at CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClass.Export

Cause

  • The integer was longer than 16 digits
  • The largest integer that Crystal Reports will accept is 15 digits plus 1 for the sign of the number

Resolution

  • Change the  Stored Procedure parameter to BigInt
  • Break the field into 2 or more parts and then manipulate these as needed

Keywords

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2