Change cell format in Report

(0) Share

Report

Posted on by Jesús García

411

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.

All responses (4)

Answers (1)

Verified answer

Layan Jwei 7,778 Super User 2025 Season 1 on at

Like (0)

Report

Change cell format in 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
Suggested answer

Waed Ayyad 8,228 Super User 2025 Season 1 on at

Like (0)

Report

Change cell format in 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
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Change cell format in 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
Suggested answer

Mohamed Amine Mahmoudi 21,751 Super User 2025 Season 1 on at

Like (0)

Report

Change cell format in Report

Hi @Jesus,

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

Best regards,

Mohamed Amine MAHMOUDI