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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

Hi..

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

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

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Roxanna ,

Take a look below article -

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

Was this reply helpful? Yes No
crmprogrammer2013 2,665 on at

Like (0)

Report

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

Thank you.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Raxanna,

I know but you need follow similar step in VS 2017 as well.

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

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

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

Hope this helps.

Was this reply helpful? Yes No
Yusi 100 on at

Like (0)

Report

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.

Was this reply helpful? Yes No