Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I'm having a little trouble configuring my system to allow me to create custom SSRS reports with Visual Studio in conjunction with CRM 2011 Online.
(I know you're busy, feel free to jump to the actual question below all this background info)
So far I tried three approaches unsuccessfully:
Option 1: SQL Server 2008 R2 SP1 / Visual Studio 2008 / Microsoft Dynamics CRM 2011 Report Authoring Extension (with SQL Server Data Tools support)
The problem I'm having here is that I'm having trouble installing BIDS with SQL Server 2008. Keeps failing. Initially I was running SQL Server Express, then learned that this does not support BIDS. Now I have SQL 2008 Express with Advanced services (v10.1.2531.0) "BIDS" and "Management Tools - Basic" didn't install on first attempt though the rest of the software did. I installed SP1 as I was informed by the system to do so then tried again installing by selecting to add feature to existing installation, fails again. I have viewed the log file but cannot ascertain the problem.
Option 2: SQL Server Data Tools / Visual Studio 2010 / Microsoft Dynamics CRM 2011 Report Authoring Extension (with SQL Server Data Tools support)
I successfully installed SQL Server Data Tools extension to VS2010. I don't however see the report templates as I do when logging into other versions of Visual Studio. The report authoring extension (with SQL Server Data Tools support) fails on installation as it says I do not have BIDS installed. I was under the impression that you can either use VS2008 with BIDS OR VS 2010 with SQL Server Data Tools.
Option 3: Visual Studio 2012 / Microsoft SQL Server 2012 / SQL Server Data Tools for Visual Studio 2012
This would be my preferred option. I see all the report templates I require in VS2012. I am aware the CRM 2011 Report Authoring Extension does not support doing it this way. I would like to create a manual data connection to CRM 2011 online, I don't have the connection option in VS2012 to select Dynamic CRM as I've seen in tutorials relating to previous versions (Type: Microsoft Dynamic CRM Fetch).
Other info: Dell Latitude E6510 / Windows 7
So, finally... my questions:
1. Can I use Visual Studio 2012 to create custom SSRS reports with Dynamic CRM online?
1. (a) Can I connect directly from VS2012 to CRM Online by providing the correct Connection string and credentials without needing the Report Authoring Extension?
2. Is it silly to have SQL Server 2008 and 2012 on the same machine, could this be causing my installation issues?
Any other thoughts/comments welcome. (I'm not particularly familiar or experienced with SQL Server-side stuff, so please take it easy.)
Many thanks in advance, Alex,
Just in case anyone is wondering... answers to my own questions above:
1. + 1(a).As far as I can tell. No. Not yet. After a long wait, a release of SQL Server Data Tools last month (Mar '13) now means Visual Studio 2012 includes all the BI reporting templates I am after but there is not a valid CRM (or any useable) connection type in order to connect to CRM online and use it as a data source. Some say the Orion update will occur before this integration. If you know otherwise please let me know.
2. Quite possibly is.
I have realised that I am running SQL Server 2012 Express which does not support BI for for SSRS. Strange that it does seem to though for VS2012. Anyway I'm upgrading to SQL Server 2012 'Standard' and am hoping that I will then be able to use VS2010 along with the SSDT to connect and work with CRM Online.
Failing that I'm uninstalling everything and doing fresh installs of SQL 2008 R2 Express w/Advanced Services, hoping that BIDS will install next time and will use alongside Visual Studio 2008.
I'm not an expert but I've spent two days on this (perhaps that's why) - But I would say, if it ain't currently broke, don't try and fix it.
Best of luck. Alex.
The best articles I found, which may save you some time:
is any action required on this thread, if not could you please mark this as answered for yourself:-)
Actually we would appreciate a better answer as to why the gap of the missing FetchXML data source in VS 2012 and SSDT has not been addressed.
Users simply installing/reinstalling software to get the combination right is hardly anything to work with when there are shops who are all using VS 2012. Installing more than one version of SQL on a server to simply remedy an obvious gap cannot be good for a client, or their licensing.
Please provide a solution that reinstates FetchXML as a data source in VS 2012.
Couldn't agree more. Why should I need a separate version of SSDT to work with CRM?? Seems like the typical sloppy implementation that is MS Dynamics CRM
Perhaps you should make the suggestion on the Connect site to raise awareness.
Here we are two years later and what a surprise, this isn't hasn't been addressed.
Business Applications communities