Question Re: Number format not applied in Technology Q&A

Number format not applied

Former Member — Mon, 28 Jan 2008 17:22:57 GMT

Post Author: pemerle

CA Forum: General

Hello,

First of all, thank you very much for all the contributions available on this forum, it used to help me so many times !!!!

I am actually working on a report with Crystal 9.2.3.884 and I encounter a strange reaction with number formats.

On my number fields, I applied a french format like that 100 000,00. A space for thousand separator and a comma for decimals.

When I launch this report on local, the result is good but when the report is generated on the server all numbers are formatted in US format (like 100,000.00). I think the report uses the regional settings of the machine it's generated from.

Does someone had the same problem and is there any solution to really force the number format on the report ?

A uge thank to you in advance,

Cordialy,

Re: Number format not applied

Former Member — Tue, 29 Jan 2008 07:54:30 GMT

Post Author: amr_foci

CA Forum: General

i've the same thing with WebI,, no one could help??

Re: Number format not applied

Former Member — Tue, 29 Jan 2008 11:17:13 GMT

Post Author: pemerle

CA Forum: General

I did some tests today switching regional settings from English to French and then from French to English. Unfortunatly it didn't changed anything...

Re: Number format not applied

Former Member — Tue, 29 Jan 2008 11:30:17 GMT

Post Author: amr_foci

CA Forum: General

hahaha, i did the same too , at the server side and at my client side too,, and nothing new

Re: Number format not applied

Former Member — Tue, 29 Jan 2008 13:50:16 GMT

Post Author: pemerle

CA Forum: General

For information, the same problem has been reported here:

http://technicalsupport.businessobjects.com/cs/forums/permalink/11350/11350/ShowThread.aspx#11350

http://technicalsupport.businessobjects.com/cs/forums/permalink/15662/15662/ShowThread.aspx#15662

http://technicalsupport.businessobjects.com/cs/forums/permalink/8778/8778/ShowThread.aspx#8778

Re: Number format not applied

Former Member — Tue, 29 Jan 2008 14:29:52 GMT

Post Author: pemerle

CA Forum: General

I've just found a way to solve this problem.

Do not drag directly your field from the source to the report but insert an empty text object and put in your number field. Apply the format on your number field inside the text object and you will see that your field format works now.

Please let me know if it works well for you too.

Re: Number format not applied

Former Member — Fri, 01 Feb 2008 13:24:05 GMT

Post Author: AndersG

CA Forum: General

Great! Who would have thought of that? It does work, but the downside is that I have hundreds of reports that I have to go through...

Re: Number format not applied

Former Member — Fri, 01 Feb 2008 19:17:32 GMT

Post Author: pvierheilig

CA Forum: General

While you'll still have to go through each report, this may avoid changing each object:

File -> Options -> Fields -> Number.

Chances are you have removed the option of 'System Default' by changing the formats on individual objects. You have two choices:

Reset to 'System Default' and set each machine to the appropriate regional/locale settings, or change the default format for the number object specifically in this window, which will apply to all number objects. I do not recall if it takes effect immediately or not, so you may have to close the report, after saving it, and open it again.

Another consideration will be any conditional formatting you may have applied that will orveride these settings.

Re: Number format not applied

Former Member — Tue, 05 Feb 2008 18:22:11 GMT

Post Author: AndersG

CA Forum: General

OK. Thanks. I will try.