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

apollo7
apollo7 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Feridun KadirPrincipal Consultant

Commented:
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.

Author

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

Author

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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Feridun KadirPrincipal Consultant

Commented:
Try my URL again, but remove the final "?"

So it should be https://www.microsoft.com/en-us/download/details.aspx?id=50375

Author

Commented:
That worked, download the exe.  I will reboot and try again.

Author

Commented:

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


CRM2016-Bids-ENU-i386
Feridun KadirPrincipal Consultant

Commented:
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?

Author

Commented:
Thanks, will check

Author

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
Principal Consultant
Commented:
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.

Author

Commented:
Any specific version so that I can also get the CRM Report Authoring Extensions for FetchXML reports?
Feridun KadirPrincipal Consultant

Commented:
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.

Author

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 Consultant

Commented:
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.

Author

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

Author

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.

Author

Commented:
Thanks for answering my questions and getting my problem solved

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial