Hi, I'm using a pivot table in BI Publisher, and one of the rows that I'm inserting his a concatenation and I need to use some padding in it:
rpad((AP_AGING_TRANSACTION.INVOICE_NUMBER),10) || ' ' || AP_AGING_TRANSACTION.NET_DATE || ' ' || APPLICATION_OBJECT_SECURITY.NAME AS "INVNUM",
But I can't see the padding when I look at the report. Is there a way to do it?
For rpad, use this syntax:<?xdofx:rpad(INVOICE_NUMBER,10)?>
For concatenation, use either of these examples for sytax:
<?xdofx:3||2?> or <?concat(' ' , NET_DATE, ' ', NAME)?> -- in this case I am assuming that NET_DATE AND NAME are fields in your xml file.
In your case, you would need this:
<?xdofx:rpad(concat(INVOICE_NUMBER, ' ' , NET_DATE, ' ', NAME), 10)?>
It would be better to get this padding and concatenation done via your query and thereby in your xml file rather than doing this in RTF if possible..