SAP Knowledge Base Article - Public

2341335 - Formula Editor shows unreadable characters in Crystal Reports

Symptom

  • Unable to read the formula.
  • Strange characters displayed in the Formula Editor.
  • Unable to modify a formula because when opening it in the Formula Workshop in Crystal Reports, it displays unreadable characters.
  • When opening the same report on a different computer, it is possible to see the formula text.
         
       
  • Note: Images, video and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports designer, open a report.
  2. Edit a formula, by right clicking on a formula, and selecting "Edit..."
  3. In the "Formula Workshop" window, notice the formula displays unreadable characters, and therefore it is not possible to modify the formula.
     
    Formula Editor - 03.png

Cause

  • The font used to display the formula text is either unavailable, or it is a font that does not have alphanumeric characters, like a barcode font.

Resolution

  • Change the Formula Editor Font in Crystal Reports designer:
         
    1. Open Crystal Reports designer.
    2. Under the menu "File", select "Options..."
    3. In the "Options" window, select the tab: "Formula Editor"
       
      Formula Editor - 01.png  
        
       
    4. In the "Formula Editor" options, change the font.      
      Note: We generally suggest to use a fixed font size, like "Courier New", but you can select any fonts.
       
      Formula Editor - 02.png   
         
        
    5. Click "OK" to accept the change.
              
      Note: Options selected in this  menu, are for Crystal Reports designer, for the specific computer only. Those options are not stored with the report.

Keywords

CR, Formula Editor, Barcode text , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020