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

SSRS Report change thousand comma to space

(1) Share

Report

Posted on by Hein Kruger

629

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

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

Thanks

Was this reply helpful? Yes No
Hein Kruger 629 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

rohithmp 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No