Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Enable Filter on Subgrid
Microsoft Dynamics CRM (Archived)

Enable Filter on Subgrid

(0) ShareShare
ReportReport
Posted on by KingNola 30

I have a client with some interesting requirements.  In a normal view you have the option to click on the filter icon and filter the data presented, but I don't see that option in the subgrid on a form.  If I pop the subgrid out of the form, the option becomes available.   I did some research and came up with nothing.  Most of it has do do with fetchXML filtering, which is not the option I am looking for...

Is there a way to enable the filter option either through properties or scripting.  Am I missing something.  I'm surprised no one has asked this.

*This post is locked for comments

  • KingNola Profile Picture
    KingNola 30 on at
    RE: Enable Filter on Subgrid

    I solved this problem years ago, but the solution sucked.  I have since moved away from this god awful system.  If I remember and its been quite a few years, I created a form with dropdowns, used the data from the drop downs to filter a SOAP request that was then applied to the subgrid.  It was cumbersome, but it worked until our contract expired, and we moved on to bigger an better CRM Systems.  Good luck!

  • dieter.m Profile Picture
    dieter.m 25 on at
    RE: Enable Filter on Subgrid

    Ahh! We are still stuck on on-premise and that's why we can only dream about it ;) Thanks for your tip!

  • Federico Pelliccia Profile Picture
    Federico Pelliccia 75 on at
    RE: Enable Filter on Subgrid

    No, I am talking about new subgrid

    new-subgrid.png

    This is a only read subgrid, but now you can filter and drag column. Plus, you can see the total number of the records

  • dieter.m Profile Picture
    dieter.m 25 on at
    RE: Enable Filter on Subgrid

    If this means the EditableGrid, then it has other disadvantages. For example, it does not show how many results and how many pages there are.

  • Federico Pelliccia Profile Picture
    Federico Pelliccia 75 on at
    RE: Enable Filter on Subgrid

    Yes, new subgrid has filter on column's header

  • dieter.m Profile Picture
    dieter.m 25 on at
    RE: Enable Filter on Subgrid

    Hello all,

    a few years have already passed. Are there any new or further possibilities in the meantime?

  • Suggested answer
    Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Enable Filter on Subgrid

    Hi King,

    Currently this feature is not available in CRM. If you would need go through webresource customization

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Enable Filter on Subgrid

    Hi,

    There currently is no way of filtering subgrids on the form in the same way that you can in the full grid - however if you move to Dynamics 365 you can enable editable grids that have the filtering option built in.

    See community.dynamics.com/.../dynamics-365-editable-grids

    Hope this helps

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans