1517519 - Database Connector Error: ' Database Vendor Code: 8114 ' when passing parameters to a report in VS .NET

SAP Knowledge Base Article - Public

1517519 - Database Connector Error: ' Database Vendor Code: 8114 ' when passing parameters to a report in VS .NET

Symptom

  • Report works as expected in the Crystal reports designer
  • The following code is used in a Visual Studio application to set the report parameters:
CrystalReport.SetParameterValue("@BDATE", "09/23/2010")
CrystalReport.SetParameterValue("@RPTBY", "L")
  • This results in the error:

Database Connector Error: ' Database Vendor Code: 8114 '
Error in File <ReportName>
Database Connector Error

Cause

  • The parameters were set in incorrect order

Resolution

  • Set the parameters in the same order as would be done when running the report in the Crystal Reports designer
  • In this case:
CrystalReport.SetParameterValue("@RPTBY", "L")
CrystalReport.SetParameterValue("@BDATE", "09/23/2010")
  • Or, set the parameters by name:
ReportDocument.SetParameterValue("YourParameterName", "YourValue")

Keywords

KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2