I'm trying to write a report in VS 2012 for CRM 2011 online.
I've been following the instructions here:
http://blogs.msdn.com/b/crm/archive/2010/10/19/getting-started-with-custom-reports-in-the-cloud.aspx
I've installed Microsoft SQL Server DataTools and I'm trying to install Microsoft Dynamics CRM 2011 Report Authoring Extension, but I get an error message saying that BIDS for VS 2008 is not installed. So I obviously have all the version mixed up.
What line up do I need, does anyone know? Should I use VS 2010? All my other development is in 2012 though. I've written reports for CRM 4 in VS 2005/2008, using SQL to retrieve data from the database. This time, as it's CRM online and in the cloud, I need
to use fetch XML.
I've spent about 2 days trying to get this sorted, and I haven't even started the actual report development! I need to use something more than just the report wizard as I'm using Fetch XML in my report - which connects 3 separate entities, so it's complex
enough.
Any help appreciated! I'm getting quite confused at this stage with all the options. Thanks.