Crystal Reports Number to Text Syntax (no currency)

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Number to Text Syntax (no currency)

Author	Message
Becantor Newbie Joined: 28 Jul 2017 Online Status: Offline Posts: 5	Topic: Number to Text Syntax (no currency) Posted: 07 Aug 2017 at 12:34pm
	Hi, Looking for the proper way to convert 2000 to "Two Thousand" in a report. I have tried to use ToWords (), but this adds the currency syntax to the end (i.e. "Two Thousand and xx / 100" ) What is the syntax to use to JUST display the number spelled out without the current add on Thanks
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 08 Aug 2017 at 4:02am
	I think there is an option to not display that. Try ToWords({somefield, 0). Help should always be available in CR
	IP Logged

Becantor Newbie Joined: 28 Jul 2017 Online Status: Offline Posts: 5	Posted: 08 Aug 2017 at 7:56am
	Thanks. Adding the ,0 to the end di.d the trick
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.