FetchXML reports in Visual Studio 2012 RRS feed

  • Question

  • I am trying to create a FetchXML Report in Visual Studio 2012. I currently have Microsoft Visual Studio 2012 and Microsoft Sql Server 2012 (Enterprise Edition) installed. In addition to that, I have also downloaded and installed:

    • Microsoft SQL Server Data Tools (June 2013)
    • Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 - File Version 11.0.3369.0
    • Microsoft SQL Server Data-Tier Application Framework (July 2013)
    • Microsoft Dynamics CRM 2011 Report Authoring Extension (with SQL Server Data Tools Support)

    After creating a project and adding in a new report, I was going to add in a datasource but I couldn't find the right type of embedded connection in the dropdown list. I could not locate the option "Microsoft Dynamics CRM Fetch". Any ideas what I've missed out or done wrong? Any advice/help is greatly appreciated. Thanks in advance.

    Wednesday, August 21, 2013 8:33 AM


All replies

  • Hi,

    You must install Microsoft Dynamics CRM 2011 Report Authoring Extension.


    Hope this helps!


    Wednesday, August 21, 2013 9:10 AM
  • Hi KalimK,

    Thanks for replying. However, as I've stated in my earlier post I have already installed the Microsoft Dynamics CRM 2011 Report Authoring Extension. Still wondering why the option "Microsoft Dynamics CRM Fetch" is not showing up when I was trying to add a datasource. I have tried looking at information around the forum but couldn't quite find any solution.


    The forum thread found in the link above was probably the closest an answer I could find but it still wasn't quite exactly it since I'm using a different version of SSDT etc..

    Wednesday, August 21, 2013 9:22 AM
  • Hi ,

    I think it is not compatible with 2012 version.

    I found on MSDN the following components are required:
      • Business Intelligence Development Studio and Visual Studio 2008 Service Pack 1
    • SQL Server Data Tools and Visual Studio 2010



    Hope this helps!


    • Marked as answer by TerryCF Thursday, August 22, 2013 8:03 AM
    Wednesday, August 21, 2013 4:59 PM
  • You need to use Business Intelligence Studio 2008 as this is the supported and recommended version by Microsoft for CRM 2011
    • Proposed as answer by Roshan Mehta Thursday, August 22, 2013 9:15 AM
    Thursday, August 22, 2013 6:00 AM
  • Hi KalimK,

    Thanks for the suggestions and help. I was trying to avoid uninstalling and then installing another version of Visual Studio/SQL Server on my system so I was wondering if there was a way to work around this. In the end, found I managed to do what I wanted to by using the visual studio 2010 shell.

    • Edited by TerryCF Thursday, August 22, 2013 8:11 AM
    Thursday, August 22, 2013 8:10 AM
  • Hi Roshan Mehta,

    Thanks for the suggestion.

    Thursday, August 22, 2013 8:11 AM