Skip to main content

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

 

Be the first to reply!

Reply