Change cell format in Report

(0) Share

Report

Posted on by Jesús García

607

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,779 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,073 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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