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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
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

    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

    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

    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,514 on at

    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

    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

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Nagaraju_Matta Profile Picture

Nagaraju_Matta 121

#2
ManoVerse Profile Picture

ManoVerse 71 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans