Fluitend door het leven
APEX Linebreaks In IR
On the internet a lot is to be found about linebreaks in APEX. I thought it could be useful to put yet another description of how to show linebreaks in interactive reports, if only for my own archive ;-). On a log-table data I want to show an interactive report to show the technical process made elsewhere (through a procedure, not described here) and it's results. The logtable I use is built as follows:CREATE TABLE LOG_TABLE ( "LOGDATE" TIMESTAMP (6) WITH TIME ZONE, -- detailed time "LOG_LOCATION" VARCHAR2(200), -- place in pl/sql where log is performed "MELDING" VARCHAR2(4000) --report ) ;The source for my interactive report starts as:SELECT LOGDATE ,LOG_LOCATION ,MELDING FROM LOG_TABLE;I created an interactive report that looks like this: All text from "MELDING" is shown on one line, which is not desirable for comprehensive reading. My first attempt to change the one-line-behaviour is as follows:SELECT LOGDATE ,LOG_LOCATION ,replace(MELDING, chr(10), '<br>') melding FROM LOG_TABLE;Unfortunately, this is not enough for APEX. The next step is necessary to show linebreaks in the interactive report: make the column "MELDING" a Standard Report Column It will now show the linebreaks as wanted in the interactive report, which should help to develop (and debug) a little faster.