Skip to main content
Question

Matrix Element new line in aggregate

  • January 21, 2025
  • 0 replies
  • 65 views

Forum|alt.badge.img+4

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

 

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings