Hi all,
I try many ways to display the new line character--CHR(10) in a report in Apex 4 but fail.
The outlook of the report need to be something like this:
------------------------------------------------------------------------
ID # | Info
------------------------------------------------------------------------
2937469812 | updated successfully in table 1.
| no data found in table2.
| updated successfully in table3.
| ........
-----------------------------------------------------------------------
The report display a row in a tracking table with a particular ID #.
I ran the following SQL in Apex SQL workshop, and the new line character is missed in the table.
INSERT INTO TRACKING_TABLE (ID, INFO) VALUES (2937469812 ,'updated successfully in table 1.' || CHR(10) || 'no data found in table2.');
I also tried to insert the data with CHR(10) into a table in a remote database and the new line character is still lost. The inserted result is something like:
-----------------------------------------------------------------------------------------------------------------------------------------------------
ID # | Info
-----------------------------------------------------------------------------------------------------------------------------------------------------
2937469812 | updated successfully in table 1. no data found in table2. updated successfully in table3........
-----------------------------------------------------------------------------------------------------------------------------------------------------
Does somebody know how to insert/display the new line character in Apex report?