1211554 - Formulas missing when exporting a report to Report Definition format from Crystal Reports.

SAP Knowledge Base Article - Public

1211554 - Formulas missing when exporting a report to Report Definition format from Crystal Reports.

Symptom

  • Missing formulas.
  • When exporting a report to Report Definition format, not all formulas are listed.
  • After exporting a report to report definition format, it is not printing every formula that had been used on the report in Crystal Reports.

Environment

  • Crystal Reports XI R2
  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a couple of formulas.
  3. Add some of the formulas to the report design.
  4. Export the report to "Report Definition" format.
  5. When viewing the exported report, notice it is missing some of the formula that exist in the report.

Cause

  • Only formulas that are actually inserted on the report are outlined in the Report Definition file.
  • Formulas that are referenced in other formulas, but not directly inserted on the report are not outlined in the Report Definition file.
  • This is normal behavior.  While the Report Definition file outlines the code for formulas that are actually inserted in the report, it will not list the code for formulas that are:
    • Referenced within other inserted formulas, or
    • Referenced in conditional formula, or
    • Inserted in Text Objects.

Resolution

  • To view the code for all formulas in the Report Definition file, insert these formulas in the Report Footer, then export the report to Report Definition format again.

Keywords

REPORT DEFINITION FORMAT FILE FORMULAS REFERENE X-REF CR0SS-REFERENCE EMBEDDED Seagate Crystal Reports Exporting to Report Definition format Formulas embedded in other formulas , c2006065 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports XI R2