Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Report in Dynamics CRM 365

Posted on by
Hi Everyone
 
I am testingthe Reports Function in Dynamics CRM 365
I making the report for Specified  Entity and the Entity was created by Users.
The entity has  4 field like this  'register date', 'brand',''shop', amount,
the data type of 'register date' is 'date and time'
the date tpye of 'brand' is 'option set'
 
i would like to display the count of  brand by grouping register date  per month
so i setted the file like this on Lay out fields in report   as below
 
when i run the report , i got the result like this
 
 
but I would like to get the result as below
 
 
 
How do I change the settings, so I can get the type of report results I want?
 
 
  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Report in Dynamics CRM 365
    Hi,
     
    I'm afraid that's impossible.
    If you want to show the count of brands you can only add a Brand Grouping.
    The brand group has to have a field in it and cannot be empty.
     
    Best Regards,
    Dengliang Li
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans