• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

rpad issue in bi publisher report

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic