I have to convert amount into words like 2150 to two thousand and fifty only .
for achieving this i have used towords() function in crystal report,
i have just create new formula
ToWords({abc.amount},0)+" Only"
it returns me result but in lower case so i have converted into upperCase like this
UpperCase(towords({abc.amount},0)) +" Only"
it returns me TWO THOUSAND AND FIFTY ONLY but i need First letter capital of every word
then i used
ProperCase(ToWord({abc.amount},0)+" Only"
ProperCase() give me following result
Two Thousand And Fifty Only
Hope it will help someone :)
HappyCoding :)
Subscribe to:
Post Comments (Atom)
Postman beginner Tutorial
Hi , I have started new video series of postman tutorial hope it will be helpful:Please give me your feed back in comments and like and sub...
-
this app is not collecting any users data
-
after 30mins of struggle i found a solution:) 1)Click on Layout Button. 2)Click on Edit HTML. 3) Now, in code given below go at the botto... -
I have to display amount in Words with decimal values in my report for achieving this i wrote small formula in Crystal Report here is the...
If i use this formula , the amount of 1111.78 will show out "one thousand one hundred twelve and Cents seventy-eight Only"
ReplyDeleteSome How modify it for me
Thank you in advance.
How to make money from betting on football - Work Tomake Money
ReplyDeleteIf you're having problems finding a sol.edu.kg winning bet online for the gri-go.com day of your choosing, then there 출장안마 are งานออนไลน์ plenty of opportunities 바카라사이트 available right here.