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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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