Difference between revisions of "Exporting Multiple Lines Text Fields to HTML"
From SmartWiki
(Created page with ' 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 t…') |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | If you wish to include a [[Multiple Lines Text]] field in a report that 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 line break that will be displayed in HTML ('''<br />''') by including the following in the '''[[Calculated Value|Calculated Value]]''' of the field: | |
| + | REPLACE([this],CHAR(13,10),"<br />") | ||
| − | |||
| − | |||
| − | + | [[Category:Reports]] | |
| − | [[Category: | ||
Latest revision as of 07:43, 11 July 2013
If you wish to include a Multiple Lines Text field in a report that 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 line 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 />")
