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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Sub Grid - On Demand L...
Microsoft Dynamics CRM (Archived)

Sub Grid - On Demand Load (on expanding the Tab)

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

Can anyone let me know whether we can load the subgrids in a Dynamics form on demand?

I mean, I want to load the sub grids data only when the user is expanding the Tab that contains the Sub Grid.

Quicker answers will be appreciated.

Thanks,

Bala

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Hi,

    Create a view and put some different condition so that it won't return any record, set this view in your subgrid initially when adding subgrid.

    Write code on tabonchange set subgrid view using javascript:

    joshimandarblog.wordpress.com/.../crm-2015-applying-custom-fetchxml-to-a-subgrid-using-javascript

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Subgrids are loading asynchronously so that users can continue using CRM while the sub grids are loading. Especially if you have your tabs collapsed, the user should not even notice the loading of the subgrid. And when the decide to open the tab, the data is immediately there. Why would you want to change this behavior?

    Thanks,

    Ronald Lemmen

  • Community Member Profile Picture
    Community Member on at

    Dear Ronald,

    Yea I agree with you. But the problem here is, the clients are using IE 8 to access CRM as they have dependency of other applications which supports only IE 8.

    There we are not experiencing that the Grids are loading asynchronously as the form load taking more time while we have multiple Sub Grids on the form.

    Hence I thought of give a try to this solution.

    If you have any other solution to increase the form load time with sub grids in the form you are most welcome.

    Thanks,

    Bala

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I would expect IE8 to render the grids asynchronously as well, but if you're right (i cant test as I dont have IE8 available), then I understand your request. Obviously the best approach is to get rid of the other dependencies on IE8 as CRM 2015 doesn't support IE8 (and IE9).

    For the current situation you can look at the solution mentioned by Himbab. This does help a bit, but only minimal. The delay is mainly caused by loading the iFrame and not the data within the iFrame. Only the amount of data in the iFrame is what is reduced by Himbab's solution.

    The best approach here would be to get rid of the subgrid compeletely and instruct users to click on the left navigation bar to open up the related records.

    Hope this helps,

    Ronald Lemmen

  • Community Member Profile Picture
    Community Member on at

    Hi, any answers so far?

    The issue for me is that each subgrid initiates SQL request as result. Customer has highly  loaded CallCenter, so each request counts. Even if I specify filter with no results it will generate load to database (and it is not good solution from technical point of view)

    Any ideas?

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ZS-27011425-0 Profile Picture

ZS-27011425-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans