1918711 - Text Object option “Suppress Embedded Field Blank Line” suppressing more than expected in Crystal Reports

SAP Knowledge Base Article - Public

1918711 - Text Object option “Suppress Embedded Field Blank Line” suppressing more than expected in Crystal Reports

Symptom

  • Missing data on the report.
  • Information on the report is suppressed despite it should not.
  • When using the Text Object Formatting option: "Suppress Embedded Field Blank Line" in Crystal Reports, it suppress more text than expected.

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, that contains a database fields that have data that contains NULL or empty string.
  2. Add a Text Object in the Details section of the report.
  3. In the Text Object on the first line, type some text, like: My First Line.
  4. Still in the Text Object on the second line add 2 database fields, the first one that always returns data, and the second one that returns empty or NULL data for some records.
     
    KB01.png
      
  5. Add a third line, with a text like: Third Line.
  6. Format the Text Object to Suppress Embedded Field Blank Lines.
    - Right click on the Text Object, and select "Format Text..."
    - In the "Format Editor" window, under the tab "Common", check the option: "Suppress Embedded Field Blank Lines"

      
    KB02.png
      
      
  7. When previewing the report, notice the second line of text of the Text Object is suppressed even when the first database field on the second line contained values.
     
    KB03.png

Cause

  • The issue has been escalated for a fix.
  • Reference: ADAPT01704032.

Resolution

  • The issue is resolved in the following product updates:
       
    • Crystal Reports 2011:
      • Support Pack 09
              
    • Crystal Reports 2013:
      • Support Pack 03
             
    • SAP Crystal Reports, developer version for Microsoft Visual Studio:

 

 

Keywords

CR, empty value, blank value, suppress embedded field, blank line, suppress embedded field blank line, formatting option, formatting, crystal reports, ADAPT01704032, ADAPT01704033, ADAPT01708261, ADAPT01716211, ADAPT01717158, ADAPT01717159 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013