Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Custom Reports Using F...
Microsoft Dynamics CRM (Archived)

Custom Reports Using Fetch CRM

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I'm trying to design a custom report for CRM online, using Visual Studios. I'm using the links on this page as my primary resource: https://technet.microsoft.com/en-us/library/dn920273.aspx

All I'm trying to do is create a report that has multiple tabs, with each tab pulling data from a different entity. I don't really understand coding or programming, but I understand enough that I am able to put the report together using sample codes and XML queries of advanced finds.  

The problem is, I can't figure out how to get "Fetch CRM" as an option in Visual Studio. I've spent hours of research looking for a walk through, and I can't find anything that explains how to connect VS with CRM, so that "Fetch CRM" is an available data source for reports. 

Do I need to run "SetupBIDSExtensions"? If so, the set up sends an error message that I must reboot before running the setup, and the same message appears after I reboot. 

Any advice/recommendations to fix or workaround the problem would be greatly appreciated.

Thanks in advance!

*This post is locked for comments

  • Verified answer
    Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Custom Reports Using Fetch CRM

    Yes, I have run into that same issue.  

    This happened to me on a Windows 10 machine.  I followed the steps outlined here:

    support.microsoft.com/.../2004114

    Just be very careful when working with the registry.

    Even though the KB is for CRM for Outlook, this fix worked for RAE and I was able to proceed with installation.

    I hope this works for you as well!

    Cheers

    Nick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom Reports Using Fetch CRM

    Okay, so I uninstalled everything, then I installed everything you said, in the order you said. For some reason, I can't install the report authoring extension. When I try to install it, the error message says, "Setup cannot continue because there is a pending restart required. For additional details, see logfile......". After rebooting, I still receive the same message. Here is what the logfile says, FYI:

    "11:03:33|   Info| === Setup bootstrap logging started 11/23/2016 11:03:33 AM ===

    11:03:33|   Info| Bootstrap version: 8.0.0.1088.

    11:03:33|   Info| User: Ari Kassutto.

    11:03:33|  Error| Reboot required -- Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Uninstall C:\Users\Ari Kassutto\AppData\Local\Microsoft\OneDrive\17.3.5892.0626\amd64

    Any ideas?

    Thanks.

  • Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Custom Reports Using Fetch CRM

    Can you click on "Details" and share that info?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom Reports Using Fetch CRM

    Hi Nick, I did that but still not working, 1st I install BIDS 2012 and then RAE but does not work, thanks.

  • Suggested answer
    Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Custom Reports Using Fetch CRM

    You need "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012".  

    Install that first, then Report Authoring Extension.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom Reports Using Fetch CRM

    6457.Error.JPG

    Hi Yem94,

    I have the same issue and VS 2015 does not supporting "Microsoft Dynamics CRM 2016 Report Authoring Extension" installation, please let me know if your issue has been resolved, thanks.

    I am attaching the error from "Microsoft Dynamics CRM 2016 Report Authoring Extension"

  • Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Custom Reports Using Fetch CRM

    My hyperlink isn't working, try a Google search for "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012" to get the download.

  • Suggested answer
    Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: Custom Reports Using Fetch CRM

    You need "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012".  

    This link, along with the CRM report authoring extensions, should give you what you need.

    www.microsoft.com/.../details.aspx

    Cheers

    Nick

  • Suggested answer
    Joe Griffin Profile Picture
    Joe Griffin 1,254 on at
    RE: Custom Reports Using Fetch CRM

    Hi Yem94,

    In which case, it looks like that VS 2015 Community is not supported for the Report Authoring Extensions.

    You can download Visual Studio 2012 Express from the link below, which should be compatible with the above:

    www.microsoft.com/.../details.aspx

    Try downloading, installing and then running the Report Authoring Extensions setup again and then let us know how you get on.

    Regards

    Joe

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom Reports Using Fetch CRM

    I'm using VS 2015 Community. It looks like they're not offering earlier versions on their website without a MSDN subscription. Do you know of any ways around this?

    Thanks

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