Installing the Microsoft Dynamics Report Authoring Extensions to enable Fetchxml, need hep

Visual Studio 2012, Report Authoring Extensions


We have VS2012 and VS2015 installed locally with SSDT installed.  We are trying to install the Microsoft Dynamics Report Authoring Extensions to enable Fetchxml as an option in the datasource type.  Regardless of the version of the Report Authoring Extension download, we get an error when trying to add the Report Authoring extensions.

Need advice on which version of the report authoring extensions to install.  We have reviewed the internet extensively for an answer to this problem.

Thanks
LVL 1
apollo7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Feridun KadirPrincipal ConsultantCommented:
Have you tried this one https://www.microsoft.com/en-us/download/details.aspx?id=50375?

Also, please post the error that might help with troubleshooting.
apollo7Author Commented:
Fetidun, tried that link just now, got the dreaded MS message: We're sorry, this download is no longer available.

I will try the install again and post the error.

Thanks
apollo7Author Commented:

Just ran the CRM2013-Bids-ENU-i386.exe and got the following error.  Note: we have restarted after this error at least 20 times last night.

Restart Error
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Feridun KadirPrincipal ConsultantCommented:
Try my URL again, but remove the final "?"

So it should be https://www.microsoft.com/en-us/download/details.aspx?id=50375
apollo7Author Commented:
That worked, download the exe.  I will reboot and try again.
apollo7Author Commented:

Ran the CRM2016-Bids-ENU-i386.exe and got the following error:


CRM2016-Bids-ENU-i386
Feridun KadirPrincipal ConsultantCommented:
Did you run the setup for BIDS?  My BIDS install folder doesn't have a clientsetup.dll.  Perhaps you went to the Outlook client install folder by accident?
apollo7Author Commented:
Thanks, will check
apollo7Author Commented:
I uninstalled all the Visual Studio versions and related  SQL tools overnight.  I rebooted every time.  I then installed Visual Studio but there are  not SSDT in this install.  Should I install VS2012 or download SSDT for VS2010 (which I cant find)

Thanks
Feridun KadirPrincipal ConsultantCommented:
If you just want to create SSRS reports, then install SQL Data Tools, https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017 instead of Visual Studio.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
apollo7Author Commented:
Any specific version so that I can also get the CRM Report Authoring Extensions for FetchXML reports?
Feridun KadirPrincipal ConsultantCommented:
Good question, it might be a matter of personal preference.
But I think you can't use Visual Studio 2017 - because Report Authoring extension doesn't work on that.
So search for SQL Data tools for VS 2015 or 2013.
apollo7Author Commented:
Thanks, I will select 2013 or 2015.  By the way, Microsoft has really messed this up IMO - wouldn't the latest version have built-in support for Fetch-based reports?? While they are pushing everyone to online...

Let me know if there is some other route for online reports  that I am not aware of (other than Power BI).
Feridun KadirPrincipal ConsultantCommented:
You would think so, with regard to the latest version of VS. But I think reporting authoring extensions has always lagged behind in supported versions.

There are other third-party paid-for reporting tools that connect to Dynamics such as QlikView and Tableau. I have no experience with those products.

Did you look at using the Data Export service to export data to an Azure SQL database? If you do that you can create SSRS reports against the Azure SQL database using SQL.
apollo7Author Commented:

Feridun, this SSRS/FetchXML configuration is driving me crazy!  I keep finding the 'correct' download file, installing it, rebooting and it still does not work.  I have included a screenshot of my programs in  Control Panel, let me know if you see anything funny.  I have installed versions 2010,  2012 and 2013

Thanks


Control Panel 1Control Panel 2
apollo7Author Commented:
Feridun, I was able to get the Report Authoring Extension installed.  Thanks to you and Nishant Rana's Weblog, I got past all the obstacles and have the FetchXML report type in my datasource.
apollo7Author Commented:
Thanks for answering my questions and getting my problem solved
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.