Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

crystal report check printing (Number in words) need help

1 reply [Last post]
Thu, 09/04/2008 - 8:19am
krispsoftpro's picture
krispsoftpro
User offline. Last seen 8 years 18 weeks ago. Offline
Joined: 09/01/2008
Posts: 6

Hi,
I need help in crystal reports Check printing. While printing number in words it is printing 3,365,900.00 like
“****THREE MILLION THREE HUNDRED SIXTY-FIVE THOUSAND NINE HUNDRED AND XX / 100 ****.
My requirement is to change “XX” into “00”. If there is any number in decimal place then it is printing that number/100 but if there is no value after decimal place it is printing XX/100.So I want to avoid this XX and put ‘00’ is this possible?
Thanks in advance.
Regards,
Kris

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 11896 reads
Thu, 02/19/2009 - 3:48am
#1
Vamsi Chowdary's picture
Vamsi Chowdary
User offline. Last seen 11 years 47 weeks ago. Offline
Joined: 02/10/2009
Posts: 2
Re: crystal report check printing (Number in words) need help

Hi Kris,
I read ur requirement.
Its so simple just u need to add 0 after the amount field.
It will avoid XX/100.
Instead of 00 its better to put "only" after the amount in words.
for eg:
write a formula
towords({IGN_PENSION_AMOUNT_G.ASDF_RETGRATUTY_NUM},0)
place a text box and insert this formula and double click the text box then write the word ONLY after the formula. then u can see ur amount as

THREE MILLION THREE HUNDRED SIXTY-FIVE THOUSAND NINE HUNDRED only

Top