Skip to main content

Notifications

Dynamics 365 general forum

CRM Fetch XML Report

Posted on by Microsoft Employee

Hi,

I am trying to create my first Report in CRM via VS2017 with fetch XML.

I installed  “Microsoft SQL Server Data Tools – Business Intelligence” for my VS, but when I want to create a new Data Source, as described in many blogs with pictures, there must be Type (in Data Source wizard) "Microsoft Dynamics CRM Fetch", but in my case in Type section there is no such a Type.

Who knows why it is absent and how to get that type in my VS. Here is the link, where it shows the type to select: https://citydynamics.com/insight/thought-leadership/writing-customer-reports-using-fetchxml-in-microsoft-dynamics-365/.

Thanks!

Categories:
  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    Hi Lu Hao and Piyush Paliwal,

    Thanks to you both!

    Finally, I could install "Reporting Extension for Dynamics CRM". This link: https://community.dynamics.com/crm/f/117/t/202290 solved my error issue.

    And after that, I did as you mentioned above and it worked. Now I can see the type "Microsoft Dynamics 365 Fetch".

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: CRM Fetch XML Report

    Hi partner,

    I recommend that you keep only one version of Visual Studios in your machine, and the two versions are easy to interact with each other.

    Just keep the 2015 version of Visual Studios. This version I used in my machine is fine.

    Hope this helps.

    Best Regards,

    Lu Hao

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    Also, I have both Visual Studios in my machine. Can it the cause to that error?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    I did all the steps as you mentioned. Installed VS 2015 SSDT , but during installation of Dynamics 365 Report Authoring Extension it gave the same issue which was earlier. maybe I need to install VS 2012 SSDT ??

  • Verified answer
    Piyush Paliwal Profile Picture
    Piyush Paliwal 817 on at
    RE: CRM Fetch XML Report

    That is what am trying to say that the reporting extension is not compatible with VS 2017 SSDT. You need to do the following

    1. Uninstall VS2017 SSDT
    2. Install VS 2015 SSDT / VS 2012 SSDT (The links are already available in the system requirements section of the download link which I shared earlier)
    3. Install Dynamics 365 Report Authoring Extension (download link shared earlier).

    Let me know if still the installation fails. Once you will install the Report Authoring Extension, only then the "Dynamics 365 Fetch" would start to show up. Feel free to reply in case you have any confusion.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    I already installed SSDT with Visual Studio 2017, and it installed without errors, but as I mentioned above, "Microsoft Dynamics CRM Fetch" Type or "Microsoft Dynamics 365 Fetch" Type absent in it. Cant't find this type like in this picture : 2018_2D00_12_2D00_07-15_5F00_27_5F00_57_2D00_SSRS-Reports-for-Dynamics-365-Using-FetchXML-_2D00_-Microsoft-Dynamics-NAV-Community.png

  • Suggested answer
    Piyush Paliwal Profile Picture
    Piyush Paliwal 817 on at
    RE: CRM Fetch XML Report

    Alright I think the issue you are facing is because of the VS 2017, this reporting extension doesn't support VS 2017 yet. You can take a look at the system requirements for Reporting Extension here www.microsoft.com/.../details.aspx. I would suggest you installed the 2015 or 2012 data tools and then try installing this and you should be good to go.

    As of now the log file clearly says "Some required components are missing"

    Let me know if this helps you resolve the issue and also mark this as Verified if the solution helps.  

  • Piyush Paliwal Profile Picture
    Piyush Paliwal 817 on at
    RE: CRM Fetch XML Report

    Are you under any firewall with restrictions to download, etc?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    BIDSExtensionsSetup.zip  here is the file

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Fetch XML Report

    .

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans