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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to get the data fr...
Microsoft Dynamics CRM (Archived)

How to get the data from multiple entities to get kicked out into a readable format...

(0) ShareShare
ReportReport
Posted on by USA80 26

I am looking to see if there is a way to export the data from CRM 2016 from multiple entities all at one time?  For instance.  If I have an account, that is tied to Entity B, which is also tied to Entity C, is there a way to get all the data that is tied to the Account outputted in some way?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    Hi,

    maybe you can try document generation.

    community.dynamics.com/.../document-generation-in-dynamics-crm-2016

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi,

    You can use excl templates which works on a specific view. So if you create a view which includes fields from account and other related entity then you can create the excel template out of it. Once the template is there, you can use that template to extract the information on demand.

    You can also do some data manipulation in excel template before uploading like pivots charts.

    Take a look here:

    docs.microsoft.com/.../analyze-your-data-with-excel-templates

    www.powerobjects.com/.../dynamics-crm-2016-how-to-easily-generate-excel-templates

    Hope this helps.

  • USA80 Profile Picture
    USA80 26 on at

    This all looks like it is per entity and a view....or am I looking at this wrong?  I want to get all the data that is tied to the account record which I would need to pull the data from multiple entities as I want all the fields that are filled in only.  I can do this now using a word composed template that is pulling everything together, but this is a 3rd party application.  I am wondering if I can do this by using CRM and put it in excel as the tool I use now can't.  Thank you.

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    Hi,

    the document generation does support grab all related entities record. Make sure you choose the relationship when export from CRM for configuration.

    Sample

    1263.27.png

    [View:https://debajmecrm.com/2016/01/07/dynamics-crm-word-template-repeating-content-rows/:750:50]

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans