web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to change decimal ...

Microsoft Dynamics AX (Archived)

Answered

How to change decimal separator (.) to (,) in SSRS report

(0) Share

Report

Report

Posted on by Vignesh R

535

Hi All,

Is it possible to change the decimal separator (.) to (,) in ssrs report?

For e.g.

1. 15200.00 to 15200,00

2. 100.00 to 100,00

3. 16170.21 to 16170,21

Thanks and Regards,

Vignesh

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Vignesh,

Have you try to use Replace(Format()) ?

Please refer this :https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8b5fc865-1780-455d-89b9-0f3676f8be62/thousand-seperator-as-dot-in-reports-instead-of-comma?forum=sqlreportingservices

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

Hi Wang,

The above link is helped me to get a correct output. Many thanks for your help.

Thanks and Regards,

Vignesh

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI Vignesh,

You are welcome.

I'm very glad to hear that it helped you.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans