Microsoft Dynamics CRM (Archived)

Microsoft Dynamics CRM Fetch type missing in VS 2017

(0) Share

Report

Posted on by crmprogrammer2013

2,665

Hello,

I tried looking online for a decent answer but couldn't find any. Hence trying here to get some suggestions.

I am working on VS 2017 using sql based queries for SSRS report. I am trying to create a fetch based report but the type is missing in the data source properties.

What am I missing? How do I get the fetch enabled?
Thanks for any help or suggestions.

*This post is locked for comments

All responses (6)

Answers (0)

Yusi 100 on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

Microsoft hasn't fully caught up with VS2017 SSRS tooling yet. so far the only recommended tools are VS2013 and VS2015 for such reports

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/analytics/report-writing-environment-using-sql-server-data-tools

Required tools as per Microsoft

The following are required to write a custom report for Dynamics 365 for Customer Engagement apps:

Visual Studio . For specific versions, see Dynamics 365 for Customer Engagement Report Authoring Extension requirements.

SQL Server Data Tools . This is a report authoring environment that is used as a plug-in Visual Studio.

For Microsoft Visual Studio 2015 you need SQL Server Data Tools in Visual Studio 2015.

For Visual Studio 2013: You must download and install Download: Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013.

For Visual Studio 2012: You must download and install Download: Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012.

For Visual Studio 2010: You must select and install the SQL Server Data Tools (SSDT) feature that is included with SQL Server 2012 or SQL Server 2012 Express on the computer that is running Visual Studio 2010. Download: Microsoft SQL Server 2012 Express.

Dynamics 365 Report Authoring Extension. This is required if you are writing custom Fetch-based reports. Notice that Dynamics 365 for Customer Engagement apps only supports Fetch-based reports. Dynamics 365 Report Authoring Extension must be installed on the computer where Visual Studio and SQL Server Data Tools are installed. Download: Dynamics 365 Report Authoring Extension. For installation instructions, see Install Dynamics 365 Report Authoring Extension.
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

Hi,

You can download the latest version (V9) from the below location:

www.microsoft.com/.../confirmation.aspx

Hope this helps.
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

Hi Raxanna,

I know but you need follow similar step in VS 2017 as well.
crmprogrammer2013 2,665 on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

I am using VS 2017. The ones you suggested are for VS 2015.

Thank you.
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

Hi Roxanna ,

Take a look below article -

community.dynamics.com/.../ssrs-reports-for-dynamics-365-using-fetchxml
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

RE: Microsoft Dynamics CRM Fetch type missing in VS 2017

Hi..

You need Microsoft Dynamics 365 Report Authoring Extension to be installed, for fetch based reports.

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