{"id":954,"date":"2014-09-22T09:46:44","date_gmt":"2014-09-22T04:16:44","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=954"},"modified":"2014-09-22T09:46:44","modified_gmt":"2014-09-22T04:16:44","slug":"bids-development-environment-for-sql-server-2012","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2014\/09\/bids-development-environment-for-sql-server-2012\/","title":{"rendered":"BIDS Development Environment for SQL Server 2012"},"content":{"rendered":"<p style=\"text-align: justify;\">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 \u201cBIDS\u201d because SQL 2012 provide \u201cSQL data tool\u201d through which you can develop SQL based reports.<\/p>\n<p style=\"text-align: justify;\">But for fetch based reports you require to install \u201cCRM Report Authoring Extension for 2013\u201d as well as Visual Studio 2010 service pack 1 as shown below:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2014\/09\/21.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-956\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2014\/09\/21.png\" alt=\"2\" width=\"887\" height=\"512\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">So if you create Report server project then you will be\u00a0able to see \u201cMicrosoft Dynamic CRM fetch\u201d option under data source properties of report as shown in below screen shot:<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-955\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2014\/09\/17.png\" alt=\"1\" width=\"916\" height=\"367\" \/><\/p>\n<p style=\"text-align: justify;\">Please note:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Visual Studio 2010 cannot be installed on Windows 8 and 8.1<\/li>\n<li>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.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Hope this helps!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 \u201cBIDS\u201d because SQL 2012 provide\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2014\/09\/bids-development-environment-for-sql-server-2012\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[21,22,24],"tags":[791,1434,1651,1792],"class_list":["post-954","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","tag-fetch","tag-report","tag-sql","tag-visual-studio"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/954","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=954"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/954\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}