BIDS Development Environment for SQL Server 2012

By | September 22, 2014

In order to develop fetch based reports for CRM 2013 you require to have report development environment. You can do this report development on VS (Visual Studio) 2008 using BIDS for Visual Studio 2008. Else, if you have SQL server 2012 installed then you can do report development without installing “BIDS” because SQL 2012 provide “SQL data tool” through which you can develop SQL based reports.

But for fetch based reports you require to install “CRM Report Authoring Extension for 2013” as well as Visual Studio 2010 service pack 1 as shown below:

2

So if you create Report server project then you will be able to see “Microsoft Dynamic CRM fetch” option under data source properties of report as shown in below screen shot:

1

Please note:

  • Visual Studio 2010 cannot be installed on Windows 8 and 8.1
  • Visual Studio 2012 is not yet compatible with CRM Report Authoring Extension for 2013 hence you cannot develop fetch based reports using Visual Studio 2012.

Hope this helps!

Leave a Reply