Kind of a pain but, what you have to do is when the data is saved on the form into which the data is entered, you'll need to replace your line breaks with the HTML code, <br>.
Then, on the report, change the "Display As" Column Formatting setting to "Standard Report Column"
I guess with this idea, the user would have to type in '<br>' every time you want a line break. And on the data entry page, in that particular field, you'd see the '<br>'. Unless there was a way / process to replace all line break characters (which I think is /n....I think..or that represents an end line. I forget, I'd have to look it up again) with '<br>'.
Thanks for your input though.
Well, yes, you can, for sure do that. I don't think it is as hard as you think. The most fool proof way, and the way that will require the least effort on your part, is to do it via a table trigger.
Assume your table is named MY_TABLE and the column into which you want to to this is named DESCRIPTION.
CREATE OR REPLACE TRIGGER TR_SET_HTML_LINE_BREAKS
ON MY_TABLE REFERENCING NEW AS new OLD AS old
FOR EACH ROW
CRLF CONSTANT CHAR(2) := Chr(13) || Chr(10);
:new.DESCRIPTION = Replace( :new.DESCRIPTION, CRLF, '<BR>' );
:new.DESCRIPTION = Replace( :new.DESCRIPTION, Chr(13), '<BR>' );
:new.DESCRIPTION = Replace( :new.DESCRIPTION, Chr(10), '<BR>' );
You could also change the SELECT on the report itself to do this translation when the data is pulled (just nest those Replaces from the trigger above). That would do the same thing and not require you to actually manipulate the data in the DB.
Did these suggestions work for you? If so, mind marking one of the answers as Correct?