Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
The sql query would be:
Select productname, todate, fromdate.. From summary
Join orders where id=id
Group by name
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 :
I hope it helps to you.
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
Pls refer below link,
I hope it helps,Thanks.Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365.
I did a workaround. Populating temp table using flow and using fetch xml for the temp table to retrieve the values i needed.
Business Applications communities