Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to show latest related entity of a related entity on a subgrid view?

Posted on 25 Oct 2018 13:28:15 by 285

I have an entity for schools, students, and courses. There are relationships set up between schools and students and between students and courses. I need to show the list of students enrolled at the school and their latest successful course completion - all on the school form. The list view on the school form would have the "student name" and "latest completed course code" columns.

How would I accomplish this? I would prefer a method that won't require building a plugin or a web resource, as I'm pretty sure it can be done with those, it will just take extra development.

The main part I'm stuck at is how would I show the latest successful course that the student completed? I don't believe views and subgrids support that functionality. Maybe a calculated field on the student entity that will pull the latest completed course from the related courses entity? I'm not certain that the business logic that you can program calculated fields with supports this.

*This post is locked for comments

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on 26 Oct 2018 at 02:56:38
    RE: How to show latest related entity of a related entity on a subgrid view?

    Hi,

    I would suggest you to build a SSRS because you can build your own queries. It is much more easier to be achieved.

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

Featured topics

Product updates

Dynamics 365 release plans