Decimal formatting

Hi,

we have a decimal data field and we want to format it in the correct langauge specific formatting (decimal point is a "comma" in Germany...). We tried different format strings but we always get a decimal point (really a point). Is there any way to format a decimal the way it's defined in the Windows language settings? Always with 2 digits after the point (so exactly like the currency without the currency symbol)?

Thanks,

Thomas

The "Report" element has a Language property. Make sure the Language property is set to "DE-de" or e.g. to =User!Language (to run the report with the language set on the requesting client).

Then, assuming the field value has a numeric datatype (and is not an already formatted string), you can e.g. set the format property on the textbox to N2 to get the desired formatting.

Check these links for more information on format strings:
* http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
* http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp

-- Robert

|||

Robert,

Thanks... Works perfectly...