{"id":127,"date":"2012-12-04T09:45:47","date_gmt":"2012-12-04T15:45:47","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=127"},"modified":"2012-12-04T09:45:47","modified_gmt":"2012-12-04T15:45:47","slug":"whats-new-in-sql-server-reporting-services-ssrs-2012","status":"publish","type":"post","link":"https:\/\/cognitiveinfo.com\/?p=127","title":{"rendered":"What&#8217;s New in SQL Server Reporting Services (SSRS) 2012"},"content":{"rendered":"<p>Everybody has been bloggin about the new features in SQL 2012, so I thought it would be best to just look at one part of the offering.\u00a0 SQL Server Reporting Services (SSRS) has not gotten a much love but there are a few good improvements.\u00a0 The list is so short, I covered it in one slide while presenting at SQL Saturday #125 in Oklahoma City.\u00a0 Let&#8217;s look at each area a little more.<\/p>\n<p><strong>SSRS Data Alerts<\/strong><\/p>\n<p>This is definitely a good improvement from the user perspective.\u00a0\u00a0 It allows users (OK, they may need help) to set up subscriptions based on criteria in the report.\u00a0 An example might be only sending the AdventureWorks\u00a0 sales report when the sales amount was over $x or was in a certain region.\u00a0 I like this feature so much, I&#8217;m starting a presentation about it.<\/p>\n<p><strong>Power View for Tabular Models<\/strong><\/p>\n<p>The PowerView add-in allows report authors to build interactive reports against data from PowerPivot workbooks in a PowerPivot Gallery or tabular models deployed to an SSAS 2012 instance.\u00a0\u00a0 For a good overview see: <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh213579.aspx\" target=\"_blank\" rel=\"noopener\">http:\/\/technet.microsoft.com\/en-us\/library\/hh213579.aspx<\/a><\/p>\n<p>For a tutorial:\u00a0 <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh759325.aspx\" target=\"_blank\" rel=\"noopener\">http:\/\/technet.microsoft.com\/en-us\/library\/hh759325.aspx<\/a><\/p>\n<p><strong>SharePoint Mode &#8211; Re-architected<\/strong><\/p>\n<p>This is an under the hood improvement to improve performance, management and content management.\u00a0 Probably the biggest improvement here is the security integration with based on Tickets, which probably deserves an article of its own to explain.\u00a0\u00a0 The other note is that in Integrated Mode, all administration is done through SharePoint.<\/p>\n<p><strong>SQL Server Data Tools for for Visual Studio 2010<\/strong><\/p>\n<p>Yes, we finally get to escape from BIDS.\u00a0 No more limited toolset, feeling like step-children while all the other developers get cool stuff for Christmas.<\/p>\n<p><strong>Excel and Word Renderer Updates<\/strong><\/p>\n<p>These renderers were updated to allow export to the latest versions of Excel and Word with the extensions .XLSX and.DOCX. Nice update for implementations where users want their reports in Office format.<\/p>\n<p>That is it, not a lot of love for SSRS in the 2012 release.\u00a0 The biggest improvement for me is to say goodbye to BIDS and jump into Visual Studio.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a short summary of new features found in SQL Server 2012 Reporting Services.   <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,15],"tags":[59,65,82,93],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-ssrs","tag-learning","tag-microsoft-sql-server","tag-resources","tag-sql-2012"],"_links":{"self":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127"}],"version-history":[{"count":0,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions"}],"wp:attachment":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}