Difference between revisions of "Exporting Multiple Lines Text Fields to HTML"
From SmartWiki
| Line 1: | Line 1: | ||
If you with to include a [[Multiple Lines Text]] field in a report this will be displayed or exported to HTML the line breaks will not be displayed. | If you with to include a [[Multiple Lines Text]] field in a report this will be displayed or exported to HTML the line breaks will not be displayed. | ||
| − | The line breaks stored in the [[Multiple Lines Text]] field can be converted to a break that will be displayed in HTML (<br />) by including the following in the '''Calculated Value''' of the field: | + | The line breaks stored in the [[Multiple Lines Text]] field can be converted to a break that will be displayed in HTML ('''<br />''') by including the following in the '''Calculated Value''' of the field: |
REPLACE([this],CHAR(13,10),"<br />") | REPLACE([this],CHAR(13,10),"<br />") | ||
[[Category:Reports]] | [[Category:Reports]] | ||
Revision as of 11:04, 24 March 2013
If you with to include a Multiple Lines Text field in a report this will be displayed or exported to HTML the line breaks will not be displayed.
The line breaks stored in the Multiple Lines Text field can be converted to a break that will be displayed in HTML (<br />) by including the following in the Calculated Value of the field:
REPLACE([this],CHAR(13,10),"<br />")
