Display multiline text with carriage returns in reports?

<< Click to Display Table of Contents >>

Navigation:  How do I ...? >

Display multiline text with carriage returns in reports?

In this tutorial example, we will edit an existing sample report template so that text in a multi line field displays in the report as shown when viewing the workorder itself.

 

It is recommended that you review the Report Templates Help section before proceeding for an overview of the Report Designer.

 

 

1.Open any workorder that is not yet Closed

2.Enter the following text with carriage returns into the Labor's Service Details field so that it looks similar to the screenshot below with three distinct lines of text

Multiline1

3.Save the workorder

4.Now select the Print menu option, hold down the SHIFT key on your keyboard and select the Sample Detailed Service Workorder with Grand Total report template to open it in the Report Designer

5.Select Preview in the bottom of the report designer so that you can see what the report looks like originally

Multiline6

6.Note that the Service Details is not showing in the report preview as it did in the workorder itself - there are no carriage returns, all three lines are merged together without multilines

Multiline2

7.Return to the Designer

8.Use your mouse to click on the Service Details datafield in the design panel

Multiline3

9.View the Properties tab for this datafield

10. Edit the Behaviour property MultiLine from No to Yes

Multiline4

11.Now click on Preview again

12. Now you will see that the Service Notes field displays just as you entered it in the workorder

Multiline5

13. Save your report template