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
Microsoft hasn't fully caught up with VS2017 SSRS tooling yet. so far the only recommended tools are VS2013 and VS2015 for such reports
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.
Hi,
You can download the latest version (V9) from the below location:
www.microsoft.com/.../confirmation.aspx
Hope this helps.
I am using VS 2017. The ones you suggested are for VS 2015.
Thank you.
Hi Roxanna ,
Take a look below article -
community.dynamics.com/.../ssrs-reports-for-dynamics-365-using-fetchxml
Hi..
You need Microsoft Dynamics 365 Report Authoring Extension to be installed, for fetch based reports.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (