Print Page | Close Window

Change Number Format from American To Metric

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10271
Printed Date: 19 May 2024 at 4:16am


Topic: Change Number Format from American To Metric
Posted By: zuidermark
Subject: Change Number Format from American To Metric
Date 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


Replies:
Posted By: lockwelle
Date 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.


Print Page | Close Window