I dont know if this issue goes back into version 4, but I have created a report in xTuple 5.0 Beta Windows.
The field is a text column and the user can enter carriage returns.
In the report I cannot use a field because the length of the text cannot be determined and would be truncated.
So I use the Text field, which sort of works.
If the text column data does not have TWO CRLF at the end, the text will not appear on the report.
So I have to change the text field to
special_instruction_text || E'\r\n' || E'\r\n' AS special_instruction_text_report
and add TWO CRLF
This new field will display on the report
Is this a known issue?