User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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
Thu, 09/04/2008 - 8:19am
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
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
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
Post new comment