Crystal Reports Convert a number to actual text in Portuguese

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

Topic: Convert a number to actual text in Portuguese

Author	Message
Josie Newbie Joined: 25 Apr 2013 Online Status: Offline Posts: 2	Topic: Convert a number to actual text in Portuguese Posted: 27 Apr 2013 at 9:46pm
	Hi there, I want to convert a number to text. ie . 12 to twelve. I also want to convert it from Engish to Portuguese. I only want to do it in one text field on one report. Is this possible?
	IP Logged

Gurbs Senior Member Joined: 16 Feb 2012 Location: Ireland Online Status: Offline Posts: 216	Posted: 28 Apr 2013 at 11:51pm
	I am not sure if Crystal actually translate it to different languages. To convert your number into text in English, use this formula: ucase(left(towords(truncate({table.field}),0),1)) & mid((towords(truncate({table.field}),0)),2) & ' euro and ' & towords(truncate((({table.field}-truncate({table.field}))100)),0) & ' cents'*
	IP Logged

Josie Newbie Joined: 25 Apr 2013 Online Status: Offline Posts: 2	Posted: 29 Apr 2013 at 12:23am
	Thanks I did actually manage to get this part working after I submitted the post. Have just not found anything that converts to Portuguese. i can change the Preffered Viewing Locale but then it changes for all fields on all reports. I just want to convert one field on on report
	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.047 seconds.