Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Change cell format in ...
Finance forum
Suggested answer

Change cell format in Report

Posted on by 122
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.
 
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 4,799 Super User on at
    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 Profile Picture
    Waed Ayyad 3,872 on at
    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 Profile Picture
    Hana Xue Microsoft Employee on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 7,759 User Group Leader on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans