Print Page | Close Window

Convert a number to actual text in Portuguese

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19473
Printed Date: 03 May 2024 at 2:44am


Topic: Convert a number to actual text in Portuguese
Posted By: Josie
Subject: Convert a number to actual text in Portuguese
Date 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?


Replies:
Posted By: Gurbs
Date 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'

Posted By: Josie
Date 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


Print Page | Close Window