{"id":238702,"date":"2022-07-12T09:00:26","date_gmt":"2022-07-12T16:00:26","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/visualstudio\/?p=238702"},"modified":"2022-07-11T14:23:15","modified_gmt":"2022-07-11T21:23:15","slug":"analysis-services-and-reporting-services-extensions-for-visual-studio-2022-are-here","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/visualstudio\/analysis-services-and-reporting-services-extensions-for-visual-studio-2022-are-here\/","title":{"rendered":"Analysis Services and Reporting Services extensions for Visual Studio 2022 are here!"},"content":{"rendered":"

We\u2019re happy to announce the popular and long-awaited Analysis Services<\/a>, RDLC Report Designer<\/a>, and Reporting Services<\/a> extensions are available for Visual Studio 2022!\u00a0 Here\u2019s how these Microsoft extensions for SQL Server can further enhance your business intelligence solution development environment.<\/p>\n

SQL Server Analysis Services (SSAS)<\/h4>\n

The Microsoft Analysis Services extension<\/a> adds project templates and design tools to easily create tabular and multidimensional data models in SQL Server Analysis Services, Microsoft Azure Services, and Power BI.\u00a0 These data model projects can also be integrated with source control repository providers such as Team Foundation Server.<\/p>\n

\"Figure<\/a>
Figure 1 – Analysis Services cube structure example<\/figcaption><\/figure><\/p>\n

\"Figure<\/a>
Figure 2- Analysis Services Tabular TableView example<\/figcaption><\/figure><\/p>\n

 <\/p>\n

SQL Server Reporting Services Projects (SSRS)<\/h4>\n

The Reporting Services Projects extension<\/a> provides a report definition (*.rdl) designer, projects (*.rptproj), and wizards for creating professional reports for Microsoft Reporting Services.\u00a0 The designer lets you modify, preview, and deploy report definitions and datasets within Visual Studio.<\/p>\n

\"Figure<\/a>
Figure 3 – Reporting Services dataset creation example<\/figcaption><\/figure><\/p>\n

 <\/p>\n

RDLC Report Designer<\/h4>\n

To display SQL Server Reporting Services reports in WebForms and WinForms applications, Report Definition Language Client-Side (RDLC) files are used by Visual Studio Report Viewer controls. The RDLC Report Designer<\/a> extension allows you to present database displays in Visual Basic and .NET with the provided new projects definitions and adds tools to create and manage RDLC reports within Visual Studio.<\/p>\n

Continued Extension Development<\/h4>\n

Work for the SQL Server Integration Services (SSIS) extension in Visual Studio 2022 is on the roadmap for a future release.\u00a0 For more information about the progress, you can check the Visual Studio Developer Community<\/a>. \u00a0Please let us know in the comments of other important extensions you\u2019d like to see in Visual Studio 2022!<\/p>\n","protected":false},"excerpt":{"rendered":"

We\u2019re happy to announce the popular and long-awaited Analysis Services, RDLC Report Designer, and Reporting Services extensions are available for Visual Studio 2022!\u00a0 Here\u2019s how these Microsoft extensions for SQL Server can further enhance your business intelligence solution development environment. SQL Server Analysis Services (SSAS) The Microsoft Analysis Services extension adds project templates and design […]<\/p>\n","protected":false},"author":651,"featured_media":233724,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1030,1388,155],"tags":[294,357,12,6815],"class_list":["post-238702","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data","category-extensibility","category-visual-studio","tag-extensions","tag-sql","tag-visual-studio","tag-visual-studio-2022"],"acf":[],"blog_post_summary":"

We\u2019re happy to announce the popular and long-awaited Analysis Services, RDLC Report Designer, and Reporting Services extensions are available for Visual Studio 2022!\u00a0 Here\u2019s how these Microsoft extensions for SQL Server can further enhance your business intelligence solution development environment. SQL Server Analysis Services (SSAS) The Microsoft Analysis Services extension adds project templates and design […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/238702","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/users\/651"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/comments?post=238702"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/posts\/238702\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media\/233724"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/media?parent=238702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/categories?post=238702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/visualstudio\/wp-json\/wp\/v2\/tags?post=238702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}