Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
FetchXML reports in Visual Studio 2012 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You must install Microsoft Dynamics CRM 2011 Report Authoring Extension.

    http://www.microsoft.com/en-us/download/details.aspx?id=27823

    Hope this helps!

    Thanks!

    Wednesday, August 21, 2013 9:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    http://social.microsoft.com/Forums/en-US/9a88c92d-a8a4-439e-a2ef-9f3a5e859128/fetch-xml-reports-in-visual-studio-2012

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
      -OR-
    • SQL Server Data Tools and Visual Studio 2010

    http://social.microsoft.com/Forums/en-US/a528f2bf-306c-4fea-918a-8c4bd3d0e7d5/how-do-you-create-a-fetch-based-report-for-crm-2011-online-using-sql-server-2012-and-visual-studio

    http://community.dynamics.com/crm/f/117/t/105090.aspx#.UhTu5CS3TxM

    Hope this helps!

    Thanks!

    • Marked as answer by TerryCF Thursday, August 22, 2013 8:03 AM
    Wednesday, August 21, 2013 4:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Roshan Mehta,

    Thanks for the suggestion.

    Thursday, August 22, 2013 8:11 AM