SAP Knowledge Base Article - Public

1320234 - Error occurs when exporting and setting qualified table name using Crystal Reports Java Runtime

Symptom

  • Crystal Reports Java code is changing the database properties at runtime, and then exporting the report to PDF.
  • The program crashes on the call: reportClientDocument.getPrintOutputController().export (ReportExportFormat.PDF);
  • This same report and report program worked correctly with JRC 1.
  • The error messages in the stack trace found in the console are: 
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: InternalFormatterException---- Error code:-2147467259 Error code name:failed
Caused by: com.crystaldecisions.reports.dataengine.DataEngineException: Exception in formula '{your_formula_name}' at '{your_database_field}': This field name is not known.
Caused by: com.crystaldecisions.reports.formulas.FormulaException: Exception in formula '{your_formula_name}' at '{your_database_field}': This field name is not known.

Environment

  • Crystal Reports for Eclipse 2.0
  • JDK 1.6
  • Tomcat 6.x

Cause

  • Issue is occuring because a qualified table name is being appended to the report's qualified table name in the application, for example: table.setQualifiedName(TABLE_NAME_QUALIFIER + table.getName());
  • This works in Crystal Reports for Eclipse 1.0 but didn't work in Crystal Reports for Eclipse 2.0

Resolution

Remove the line of code that sets the qualified table name for the table.

Keywords

KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem

Product

Crystal Reports for Java 1.0