RDLC formatting number according to locale settings

Question

I am using RDLC reports on my web page to show some data as a local report. Everything works fine but the numbers are not formatted according to my locale culture settings (sl-SI) and I am running out of ideas how to fix the problem.

Example. I have a TextBox of value:

=First(Fields!Count.Value, "PhoneCallsDS")

where “Count” is integer, and the format is:

Number
Use regional formatting = yes
Decimal places=0
Use 1000 separator(.)=yes

In the code before the report is populated I set the culture:

    CultureInfo cInfo = new CultureInfo(“sl-SI”, false);
    Thread.CurrentThread.CurrentCulture = cInfo;
    Thread.CurrentThread.CurrentUICulture = cInfo;

After this I would expect the text box value to be formatted 2.358 as required by the sl-SI culture but is 2,358.

Does anybody knows what I am doing wrong?

Thank you!

Cerkvenic · Accepted Answer · 2012-06-04 10:04:30Z

9

I found the solution of this problem, and would like to shere it with the comunity:

Go to the RDLC report.
Click on the report field (not on the content)
Go to the "Properties"
Set the "Language" property to your locale (in my case "sl-SI").

That's all.

You can do it programmatically by setting the property "Language" to equal a report parameter having the value of the wished locale ....

Thak you ...

edited Jun 4, 2012 at 10:04

answered Jun 4, 2012 at 9:32

Cerkvenic

3772 gold badges3 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Serhii Kyslyi Over a year ago

I setted expression for Language "=First(Fields!CultureName.Value, "QualerServiceOrder")" and got the next exception "The expression used for the language of 'body' refers to a field. Fields cannot be used in report language expressions."

Heinzi · Accepted Answer · 2019-05-15 10:18:35Z

0

As an addition to Cerkenvic's great answer:

If you set the report's Language property to the following expression:

=User!Language

the RDLC engine will use the current thread's locale without you having to implement and fill a custom report parameter.

answered May 15, 2019 at 10:18

Heinzi

173k61 gold badges386 silver badges554 bronze badges

Collectives™ on Stack Overflow

RDLC formatting number according to locale settings

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related