Skip to main content

Notifications

Dynamics 365 general forum

product Report based Fulfilled and canceled order

Posted on by Microsoft Employee

Hi

I sales services in CRM based Month Unit. in the middle of service time, customer canceled the service.

For exmaple:

order created : 21 jan 2019

Product: Service A

Unit: Month

Quantity: 12

on August, Customer Canceled the Service.

Now I would  like to have report to show me:

7 months sales service A

and 

4 month Canceled Service A

how can I have report like this? 

thanks for your help.

Categories:
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: product Report based Fulfilled and canceled order

    Hi Mohammad Saberi,

    This guide explains how to create SSRS Reports for Dynamics 365 using FetchXML.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: product Report based Fulfilled and canceled order

    would you explain more please?

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: product Report based Fulfilled and canceled order

    Hi Mohammad Saberi,

    You can create this report in SQL Server Reporting Services (SSRS).

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans