Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Creating Chart that Counts Total Records in Entity

(0) ShareShare
ReportReport
Posted on by 87

Is it possible to create a single chart in CRM that will display the total record count from about five different entities?

I have explored a few ways already and the link entities within CRM will not work as there is no relationship between the entities. 

Thank You

*This post is locked for comments

  • arminos Profile Picture
    arminos 87 on at
    RE: Creating Chart that Counts Total Records in Entity

    Yeah, I've hit many limitations recently with charts and some with FetchXML. I think integrating SSRS reports on our dashboards will be something I have to start doing.

  • Verified answer
    RE: Creating Chart that Counts Total Records in Entity

    No, not with out of the box CRM functionality since a chart is based on 1 primary entity.  

    If you have the ability to write SQL and SSRS, you can write a query that counts records in your specified entities and use it to populate a chart.  Then, you can put the report in a variety of places.

    The user entity is 1 link between all of the entities in the system for ownership based entities.  If it is acceptable to show records per user, the following articles may help you.  

    community.dynamics.com/.../microsoft-dynamics-crm-record-count-reports

    crmchartguy.wordpress.com/.../multiple-entities-in-one-ms-crm-chart

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans