File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes rpad issue in bi publisher report Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "rpad issue in bi publisher report" Watch "rpad issue in bi publisher report" New topic
Author

rpad issue in bi publisher report

sabari vnathan
Greenhorn

Joined: Sep 23, 2013
Posts: 1
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: rpad issue in bi publisher report