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
- In Crystal Reports, create a report off any data source.
- 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>
- Insert the formula on the report.
- 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.
- When viewing the report, it now displays the paragraphs, but notice it doesn't have space between the paragraphs.
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.
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:
- 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>")
- Insert the formula on the report.
- 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