Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Change Number Format from American To Metric Post Reply Post New Topic
Author Message
zuidermark
Newbie
Newbie


Joined: 21 Apr 2010
Location: Netherlands
Online Status: Offline
Posts: 2
Quote zuidermark Replybullet Topic: Change Number Format from American To Metric
    Posted: 16 Jun 2010 at 4:19am
We have a database that contains numbers in the American format instead of the Metric format. We normally work with databases with numbers in Metric Format.

Crystal Reports recognises a field is numeric and converts it to Metric format but incorrect.

When a field contains a number with no decimals it's ok.

But a number with decimals is converted wrong because the Decimalsign "." (dot) is being ignored.

F.e. 500.91 is converted to 50091,00.

Is there a solution for this that Crystal Reports converts the American format to Metric on the correct way?

We work with Crystal Reports 2008
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 17 Jun 2010 at 3:08am

you could create a formula that will replace the decimal point with a comma, instead of having CR do it.

Sorry, I don't more about how CR converts numbers.
IP 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.