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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Fetch XML query
Customer experience | Sales, Customer Insights,...
Suggested answer

Fetch XML query

(0) ShareShare
ReportReport
Posted on by sjov 105

Hi. 

Can anyone help me write a fetch xml query?

I have to create a SSRS report where I will display information grouped by customers for all services.

So each customer has an order. In that order I have services he uses.

So I have to group the customers and list all services he uses with from-to date, contract duration, the total amounts, total costs, etc.

I dont know how to implement this in fetch xml. 

I have the same question (0)
  • sjov Profile Picture
    sjov 105 on at
    RE: Fetch XML query

    The sql query would be:

    Select productname, todate, fromdate.. From summary

    Join orders where id=id

    Group by name

  • onurizgi Profile Picture
    onurizgi 360 on at
    RE: Fetch XML query

    Hi Sjov,

    Can you try FetchXMLBuilder tool from XRMToolBox. I think so this solution helps to you. If you dont know how to use FetchXMLBuilder tool, you must follow this link :

    www.youtube.com/watch

    I hope it helps to you.

    Regards.

  • sjov Profile Picture
    sjov 105 on at
    RE: Fetch XML query

    Hi, yes i know how to use the xrm toolbox but i dont know how to mix aggregate with non aggregate attributes i one query. That is why im asking

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,512 on at
    RE: Fetch XML query

    Hello sjov,

    Pls refer below link,

    https://www.crmjetty.com/blog/how-to-create-and-save-fetchxmlquery-from-dynamics-365/

    I hope it helps,

    Thanks.

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365.

  • sjov Profile Picture
    sjov 105 on at
    RE: Fetch XML query

    I did a workaround. Populating temp table using flow and using fetch xml for the temp table to retrieve the values i needed.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 125

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 121 Super User 2025 Season 2

#3
Erin Lubben Profile Picture

Erin Lubben 73

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans