BI Publisher (MOSC)

MOSC Banner

issue with rpad in check print report

edited Sep 24, 2013 3:44AM in BI Publisher (MOSC) 8 commentsAnswered
  Hi,
We are working on the check print report

Current o/p:

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

Expected o/p:

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

The amount in text filed the word should either print on first line or second line the word should not spilt up and the remaining space should be filled with
'*' fro 2 lines.

used code:
used 2fields to display the text

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center