Freitag, 23. Februar 2018

Item type "Shuttle" - break-up entries in a report

If you use the item of type "shuttle" you enable the user to select items from an LOV and move them from left (unselected) to the right (selected):

Item of type: shuttle 
The content of the column in the table looks as follows:

In my (standard-) report it looks as follows:

My business requirement/challenge: start  a new line by '<'br'>' or 'char(10)'   instead of using ":"

So I replace in my SQL this line  U_BERUFE ,
 with:                                            replace(U_BERUFE,':','<br>' ) as U_BERUFE,

and we have:

I hope you can make use of it, if needed.
Good luck !