Is it possible to add a new line at the end of the aggregate values in a Matrix? I am using an IAL in the datasource then using a concatenated value in the aggregate.
This is what it is currently aggregating on:
col.CF$_FREE_CHARGE_REASON || ' QTY- ' || NVL(col.BUY_QTY_DUE,0) || ' / UNIT- $' || (sp.list_price * NVL(col.BUY_QTY_DUE,0)) || ' / SHIP- $' || nvl(d.note_text,0) All_Info
in the picture after the “SHIP - $0” it is adding the next row immediatly at the end of the string. I want it to go to a new line at the end instead.
I’ve tried adding a new line to the concat in the IAL but then it doesn’t work in the datasource designer
col.CF$_FREE_CHARGE_REASON || ' QTY- ' || NVL(col.BUY_QTY_DUE,0) || ' / UNIT- $' || (sp.list_price * NVL(col.BUY_QTY_DUE,0)) || ' / SHIP- $' || nvl(d.note_text,0) || u'\000A' All_Info
