SAP Knowledge Base Article - Public

1217413 - Incorrect paragraph formatting when using HTML Text Interpretation in Crystal Reports

Symptom

  • Paragraph formatting incorrect.
  • HTML paragraph tag <p> doesn't add space between paragraphs.
  • HTML Text Interpretation in Crystal Reports doesn't add a blank line between paragraphs when using the HTML tag <p>

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
       
  2. Create a formula with the HTML tags <p> to display multiple paragraphs like:
    •  
    • <p>My first paragraph</p><p>My second paragraph</p><p>My third one</p>
         
  3. Insert the formula on the report.
       
  4. Set the formula to display the text in HTML format:
      4.1  Right click on the formula, and select: "Format Field..."
      4.2  In the "Format Editor" window, select the tab "Paragraph"
      4.3  Set the "Text Interpretation" option to: "HTML Text".
      4.4  Click "OK" to accept the change.
                
  5. When viewing the report, it now displays the paragraphs, but notice it doesn't have space between the paragraphs.

paragraph - 01.png

Viewing the same html code in a web browser, it will display one bkank line between paragraph, which is what would be expected in Crystal Reports.

paragraph -2.png

Cause

  • The issue has been identified and tracked under ID ADAPT00164750

Resolution

  • There is unfortunately no product updates that resolves this issue.
         
  • To workaround this behavior, add one more paragraph tags. To do so, follow the steps below:
           
    1. Create a formula that replace the single paragraph tag with two paragraph tags separated by a space as follow:
          
           Replace({TableName.FieldName}, "<p>","<p> <p>")
             
    2. Insert the formula on the report.
           
    3. Set the formula text interpretation to HTML.

See Also

  • For more information regarding supported HTML tags and attributes with HTML Text Interpretation, please refer to the SAP Knowledge Base Article 1217084.

Keywords

CR , 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, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016