SAP Knowledge Base Article - Public

1878735 - Conditional Text Interpretation formatting ignored when a field is inserted in a Text Object in Crystal Reports

Symptom

  • RTF or HTML Text Interpretation not working.
  • Report displays RTF tags or HTML tags.
  • In Crystal Reports, when conditionally formatting a field to render text in RTF or HTML, and inserting the field in a Text Object, it ignores the text interpretation.
        
          
  • Disclaimer: Image 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 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 formula in which you insert HTML or RTF tags like:

      '{\rtf1\ansi\b RTF Text Interpretation. \b0}'
      
  3. Insert the formula in the details section of the report.
        
  4. Format the formula field to use the HTML or RTF Text Interpretation if certain conditions are met.
    • Right click on the Formula Field, and select "Format Field..."
    • In the "Format Editor" under the tab "Paragraph", click on the "X-2" button of the option "Text Interpretation"

 kbase2.png

    • In the "Formula Workshop", enter a formula that conditionally set the text interpretation to RTF for example, and enter a formula like:

           If {Customer.ID} in 1 to 10 Then crRTFtext Else crUninterpretedText
         
    • Save and close the formula.
       
  1. Insert a Text Object on the report.
       
  2. Copy the Formula Fields located in the details section.
        
  3. Drag the copied formula field on which the conditional formatting has been applied to the Text Object.

  4. When previewing the report, notice the RTF Text Interpretation is not working for the formula field inserted in the Text Object, but works for the formula field not inserted in the text object.

kbase3.png

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01687316

Resolution

  • The issue is resolved in the following product updates:
       
    • Crystal Reports 2008
      • Fix Pack 6.2
      • Service Pack 7
                 
    • Crystal Reports 2013
      • Support Pack 02
          
    • Crystal Reports for Visual Studio
      • Service Pack 7
           

Keywords

CR, Text Interpretation , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

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