Formating a number on a cell

Hi,

I have the following problem, i want the number format to appear depending on the language that the IE is on once you are using the reports on the web.

The thing is that my reports have language = default.

Format of the numbers are N0 or ###,###,###

The result is

123,234,456 with pt language ou en-us language, and i would like to be 123.234.456 in pt and 123,234,456 on en.

What am i doing wrong?

Thank you

Sorry all, my mistake in the report language tag instead of "default" it must be used "=User!Language"|||

Hi,

Be aware that when working with currency fields, you need to watch out when using the user's setting. For example if you store your data in $ and add a currency field to the report, I will see it as € since I have Dutch settings.

To prevent this, you need to set the Language property of the Report. This way, you can force the report to be displayed in the selected Culture.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

format string for dutch language

Hi everyone,

I have some measure with the following format string : #,#0.00

Now in Reporting Services my value is 1,975,647,808.55 instead of 1.975.647.808,55

I know that I can't change the format string to #.#0,00

This gives bad results in reporting Services

Any idea or solution?

thanks!!

Filip

Hello. I do not have a complete solution. We are struggling with this problem in Sweden as well.

You can use this format string '### ### ### ###.##' in SSAS2005.

It will help with avoiding the problem that all numbers will be text when you export to Excel.

The downside is that you will have to accept a dot (.) as a decimal pointer.

I have found no other way to solve this,

Kind Regards

Thomas Ivarsson