Change cell format in Report

(0) Share

Report

Posted on by Jesús García

561

Hi, I am trying to format a cell in my report as follows: =Fields!CurrencyCode.Value + / / + Format(sum(Fields!LineAmount.Value))
The problem lies in the LineAmount field, which is of type real. I need to display it so that its format is 1.000,25 but after using different options it always ends up showing a format of type 1,000.25.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Jesus,

You must use text box or placeholder properties and then set the format.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
You can check the link below to format the text box.
https://www.mssqltips.com/sqlservertip/4074/sql-server-reporting-services-formatting-and-placeholders/
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Did you try the below suggestions? If you tried it and it wasn't work, it seems you have cache issue. Try to restart reporting service, Restart SQL server service and rest usage data.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jesus,

Maybe try if this works:

Right click on your field in the design, click text box properties and tick "use 1000 separator" to true

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No