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..
That's my issue. I"m doing the padding and the concatenation in the query and it doesn't get into the XML. I don't want to us a RTF if possible.
Are you able to run the query in SQLPlus/Toad and is the output per expectations?
I tried this and it works for me:
select rpad(('De' || ' ' || 'John' || ' '||'Kim'),16, '*') as name from dual
In SQL+ it works fine, it does what is is suppose to do. It's when it gets into the reports that it doesn't work anymore.