Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 138 of 212

126 C H A P T E R 7 | Better reporting appearance of the authoring tools. In addition, these tools have been augmented by the addition of new visualizations and a new interface for working with parameters. Introducing changes to paginated report authoring tools As in prior versions of Reporting Services, there are two methods for authoring paginated reports: Report Designer A full-featured report development environment available as one of the business-intelligence templates installed in the new SQL Server Data Tools for Visual Studio 2015 (SSDT). Report Builder A standalone application that shares many common features with Report Designer. Report Designer Microsoft has released a new updated business-intelligence template in SSDT that you download from This business-intelligence template includes an updated version of Report Designer that allows you to develop reports for multiple versions of Reporting Services. By default, you can develop reports for SQL Server 2016 Reporting Services or later, as shown in Figure 7-1, but you can change the TargetServerVersion property in the project's properties to target SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014. Report authors may continue to use SQL Server Data Tools for Business Intelligence in Visual Studio 2013 to develop reports for these earlier versions, but the new features specific to SQL Server 2016 that we discuss later in this chapter are not supported. Figure 7-1: A new default value for the TargetServerVersion property in the project's properties. Report Builder Report Builder is an alternative report-development tool for power users and report developers who need only to create or edit one report at a time. You can start the ClickOnce version of the Report Builder by clicking the Report Builder button on the web portal toolbar on your report server at http:///reports. You can also download and install a standalone version of Report Builder from and then use the Windows Start menu to open it after installation. Previous versions of Report Builder use the light blue Office 2007 appearance, but the most recent version of Report Builder, shown in Figure 7-2, uses the same darker theme that appears in both Office 2016 and the Power BI Desktop application and continues to use a ribbon interface like Office applications.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016