Change ReportViewer Currency Format?

Question

Hello there, I was wondering how can I change currency format from US ($) to EURO (€) for a specific TextBox in Microsoft ReportViewer?

Because it always displays a dollar sign in front and the format is ##,###.## and as for euro it must be like ##.###,##

Answer 1

Well the solution to that problem is to change the general report rdlc language to some of European country (for example I've put it to German language) and the currency field is displaying as it is supposed.

Answer 2

As You've discovered, you need to change the Language of the report.

Some extra info: You can't seem to do this via the GUI, you need to edit the <Languauge> element in the xml of the RDLC file. this link is about RDL files, but the details are the same for RDLC.

Answer 3

To add to the options already stated:

You can set the Language property of the report through Business Intelligence Studio (VS with SSRS project support) to =User!Language. This then picks up the culture/locale of the current thread.

I had to use this when users from multiple regions used the same reports.