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