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) / SSRS Report - Currency...
Microsoft Dynamics CRM (Archived)

SSRS Report - Currency in sum

(0) ShareShare
ReportReport
Posted on by ChrisJC 1,540

I'm trying to create a Purchase Order report and I'm getting stuck on the sum of my extended amounts. All of the groupings are working correctly, it's just formatting really.

The expression

=sum(Fields!line_extendedamountValue.Value)


is pulling back the correct sum but in a generic dollar currency whereas the order record is in GBP.

How do I include the correct currency of the record (this CRM uses multiple currencies)? Or do I need to include it in my dataset and do a string concatenation?

Thanks

*This post is locked for comments

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

    Hi!

    We think that you need to change the format of the currency character from $ on which you need in textbox editing. 

    Please, pay attention on the screen attached. 

    Currency-properties.png


    Dynamica Labs http://dynamicalabs.com/

    Disclaimer:

    Any post on this page provided "as is" without warranty of any kind and is for educational and information purposes only. We disclaim any liability arising from any reliance placed on any post.

  • ChrisJC Profile Picture
    ChrisJC 1,540 on at

    Hi,

    Surely that will change it on the report, not dynamically per the order record to whatever currency is set on that order?

    Thanks,

    Chris

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