web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Formatting Currency fi...
Microsoft Dynamics CRM (Archived)

Formatting Currency field in SSRS Fetchxml report

(0) ShareShare
ReportReport
Posted on by Community Member

I have a currency field "totalamount" which is set to Currency precision 4 places at CRM level. While displaying this field in my Fetch xml report, I want to show only 2 decimal places.

I am using this expression inside the textbox: [Fields!totalamount.value]. It now displays as â‚¬â€Ž800.0000

I tried all the below options so far, but none of them are working..

1.  Format (Fields!totalamount.Value,"C")

2.  Textbox properties, set currency format to 2 decimal places.

 

Please help!

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    Try the below

    =Format(Fields!totalamount.Value,"F2")

    =Format(Fields!totalamount.Value,"#,##0.##")

  • Community Member Profile Picture
    Community Member on at

    Thanks for your rely,

    No, It doesnt work. Shows [tag:Error] in the field

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Try that also :

    =Format(Fields!totalamount.Value,"0.00")

    =Format(Fields!totalamount.Value,"#.##")

  • Community Member Profile Picture
    Community Member on at

    I had to use the [Fields!totalamountvalue.Value] to get this done, any idea why we can't format on the currency field from CRM?

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    Hi Sameera,

    The fetchxml query will return the formatted currency as a string in the field (using the user's formatting settings) - you can use the raw numeric field by adding value onto the end of the logical name (as you've already discovered).

    The reason you get an error is that formatting a string returns [tag:Error].

    Hope this answers your question.

  • Community Member Profile Picture
    Community Member on at

    Thanks Scott! That explains it all :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans