Small and medium business | Business Central, N...

SSRS Report change thousand comma to space

(1) Share

Report

Posted on by Hein Kruger

501

Hi,
I have a report that I want to change the values settings.

The thousand value is separated by a comma and the decimal is separated by a point.
I need the thousand to be separated by a space and the decimal point should become a decimal comma.

In the Textbox properties I made the changes, and the sample looks the way I want the output to be, but the output on the report is still as mentioned above for all the values.

Textbox properties:
Category: Currency
Use 1000 Separator = True
Decimal Places: 2

If I can maybe change the Number formatting that might also work.

I'm assuming there is an overall setting that is overwriting the Currency values.
The Report I'm extending is Standard Statement (ID:1316)
Thanks in advance

Categories:

Business Central

All responses (4)

Answers (0)

Suggested answer

rohithmp 2 on at

Like (0)

Report

SSRS Report change thousand comma to space

This patterns works for large digits like
Pattern - "##\,##\,##0.00"
Output - 49,82,734.00

But if the value is 0, it returns
Pattern - "##\,##\,##0.00"
Output - ,,0.00

Why is the ',' printing ! How can i avoid that?
Hein Kruger 501 on at

Like (1)

Report

RE: SSRS Report change thousand comma to space

I managed to change the thousand decimal to a space with the following format.

'R'# ##0.00;('R'# ##0.00)

The Sample looks as follow: R1 000.00
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: SSRS Report change thousand comma to space

Hi,

What you have tried till now? Is RDLC formatting working?

Thanks
Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

RE: SSRS Report change thousand comma to space

Hi, Sorry I haven't tried it.
It may be faster to open the Layout file with VS Code and edit it directly.

Hope this helps.

Thanks.

ZHU