CODEWITHSUNDEEP
reporting-services
M.JAY
M.JAY

Reputation: 193

SSRS: show comma instead of dot

I would like to have in my report a comma instead of a dot. I used this format:

=Format(Fields!True.Value,"F2")

But this shows me a dot. How can I get a comma?

Upvotes: 2

Views: 4791

Answers (3)

adopilot
adopilot

Reputation: 4500

In addition to niktrs answer Language settings for the report can be set via the properties window.

enter image description here

Upvotes: 5

iamdave
iamdave

Reputation: 12243

Alternatively, just manually set your format string.

For Example:

=format(10000000.12,"£#,#.##") will return £10,000,000.12

You can use the masks in the same way you would in Excel:
https://support.office.com/en-us/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4?ui=en-US&rs=en-US&ad=US

Upvotes: 3

niktrs
niktrs

Reputation: 10066

Number formating depends on reports selected language, so you should set it to something that matches your requirements

Upvotes: 0

Related Questions