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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Repeat Clients

(0) ShareShare
ReportReport
Posted on by 25

Hello,

I am seeking the easiest solution to generate a list of repeat clients in CRM based on the projects we’ve competed with them. The reporting module does not allow me to add conditions, for instance, any client with more than one project is considered a repeat client. Does anyone have a solution to this? Your help is greatly appreciated!

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hi CWDdkops ,

    Firstly, you can create a rollup field to count the number of related projects:

    (+) Count the of number related child records using a Rollup field - Microsoft Dynamics CRM Community

    pastedimage1636011987687v1.png

    Test:

    pastedimage1636012753109v4.png

    Now, you can use 'greater than 1' as condition to filter records:

    pastedimage1636012776658v5.png

    Result:

    pastedimage1636012790756v6.png

  • CWDdkops Profile Picture
    25 on at

    Thank you very much, Leah! I went ahead and created a rollup field. Looks like it'll take 12 hours for CRM to update if I'm not mistaken.

  • Verified answer
    Community Member Profile Picture
    on at

    Hi CWDdkops,

    Yes, you are right.

    Rollup fields are calculated by scheduled system jobs that run asynchronously in the background. The jobs can be viewed and managed by an administrator. There are two types of system jobs:

    (1) Mass Calculate Rollup Field job that runs once per rollup field 12 hours after you created or updated a rollup field.

    If you don't want to wait 12 hours, you can go Settings > System Jobs to find Mass Calculate Rollup Field job for the new craeted rollup field to Resume it.

    (Dynamic CRM follows specific naming convention for Rollup Jobs.EntityName.FieldName)

    pastedimage1636082273505v3.png

    (2) Calculate Rollup Field job that runs per entity and recalculates all rollup fields for that entity by processing the records that were created, updated or deleted since the last recalculation. The default maximum recurrence setting is one hour.

    If you want to modify recurrence, you need find Calculate Rollup Field job for current entity.

    Changing the recurrence is supported only at entity level and not on single field. So, opening the Calculate Rollup Field Job will give me this.

    pastedimage1636084387568v1.png

    Also, It is possible to manually recalculate individual rollup fields by choosing the Refresh icon next to the rollup field on the entity form. User must have write access to the record on which refresh is requested.

    For more details, you can refer following link:

    Create rollup fields in Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs

  • CWDdkops Profile Picture
    25 on at

    This is great! Thank you so much! After 12 hours, I verified that the roll up field is working. I’ll look into readjusting the occurrence. Have a wonderful weekend!

  • Community Member Profile Picture
    on at

    Hi CWDdkops ,

    Can you click Yes under "Did this answer your question?" to close this thread if my answer is helpful.

     pastedimage1636334205581v1.png

    Thanks in advance.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 176

#2
ManoVerse Profile Picture

ManoVerse 56 Super User 2026 Season 1

#3
Niki Patel Profile Picture

Niki Patel 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans