Skip to Main Content

Carriage returns to make the data or multiple values appear in a list

Gareth_SmythJan 25 2023 — edited Jan 25 2023

Hello, I would like to make a column inside an interactive report show data as a list rather than all on one line.
Here is what I have done so far:
This is what created the slash between two lot numbers which would separate them.
(LOT_NUMBER, ' / ',1) >=1 THEN REPLACE(LOT_NUMBER, ' / ', CHR(13) || CHR(13)) ELSE LOT_NUMBER END LOT_NUMBER
I done this to increase the size of the column

<span style="display:block;width:200 px;"></span>

I tried to add text wrapping in a style tag but this did not work.

image.pngI would like it to appear like this rather than W038754/ (1) / W038755 (0):
W038754 (1)
W038755 (0)
Any ideas?
I am on APEX 20.1

Gareth

This post has been answered by Gareth_Smyth on Jan 25 2023
Jump to Answer
Comments
Post Details
Added on Jan 25 2023
5 comments
47 views