Tuesday, 3 April 2012

To show the currency value in a words format -Crystal Reports

UCASE("Rupees " + {@tt1} + 
IIF ((Round({?test},2) - Int({?test})) * 100 = 0 , " Only" , " and " + ToWords ((Round({?test},2) - Int({?test})) * 100, 0) + " Cents Only" ))

 Note:
Instead of giving this parameter{@tt1} we can give ToWords (({?test}),0)

No comments:

Post a Comment