Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rpad issue in bi publisher report

 
sabari vnathan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are working on the BI-Publisher report

Current output:

One Thousand Two Hundred Forty-Six Pounds And Eigh
ty-Nine Pence Only***************************************

Expected output:

One Thousand Two Hundred Forty-Six Pounds And
Eighty-Nine Pence Only********************************

In the amount text field, the word should either print on first line or on the second line.
The word should not spilt up and the remaining space should be filled with '*' for 2 lines.

code:

used 2 fields to display the text

<?xdofx:substr(rpad(PaymentAmountText,100,'*'),1,50)?>
<?xdofx:substr(rpad(PaymentAmountText,100,'*'),51)?>


Regards,
Sabari
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic