Microsoft Sql Server 2016 Report Builder For Mac

-->

The following sections list the minimum hardware and software requirements to use or connect to Business Central online, and to install and run Business Central on-premises (version 14). Minimum means that later versions (such as SP1, SP2, or R2 versions) of a required software product are also supported.

Note

Business Central Setup installs some software if it is not already present in the target computer. For more information, see the 'Additional Information' section for each component.

Client Components

  • Sep 26, 2019  Microsoft® SQL Server® Report Builder for Microsoft SQL Server 2016. Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2016 Reporting Services. The download provides a stand-alone installer for Report Builder.
  • To install Report Builder from the download site On the Report Builder page of the Microsoft Download Center, click Download. After Report Builder has finished downloading, click Run. This launches the SQL Server Report Builder Wizard. Accept the terms in the license agreement and click Next.

To save a report as a different name. From the Report Builder button, click Save As. The Save AsReport Item dialog box opens. Browse to the report server location or to the file share where you want to save the report. In Name, type the name of the report. In Items of type, select the type of report item you are saving.

Browser Requirements

The following table shows the minimum system requirements for using Business Central in a browser.

Supported browsersRecommended browsers:
  • Microsoft Edge
  • Google Chrome 77.0 for Windows
  • Mozilla Firefox 69.0 for Windows
  • Safari 12.0 for macOS
Other supported browsers:
  • Internet Explorer 11
Cookies and JavaScript must be enabled in the browser.
Business inbox in Outlook
  • Microsoft Office 365, Microsoft Office 2019, or Microsoft Office 2016.
Sending data to Excel
  • Microsoft Office 365, Microsoft Office 2019, or Microsoft Office 2016.
Editing in Excel using the Excel Add-in
  • Excel 2019, Excel 2016, or Excel Online.
    For more information, see Exporting Your Business Data to Excel.
SharePoint Online links
  • Microsoft Office 2019, Microsoft Office 2016, or Microsoft Office 365.
Printing reports to Excel or Word
  • Microsoft Office 2019, Microsoft Office 2016, or Microsoft Office 365.
Additional informationIf you experience problems using the Business Central Web client, you can try to turn off browser tools, such as translator tools that may run in the background.

Business Central Mobile App Requirements

The following table shows the minimum system requirements for the Business Central Mobile App.

For the latest information, see the app in the Windows Store, App Store, or Google Play.

Supported operating systems
  • Windows 10 S, Home, Pro, Enterprise, or Education (32-bit and 64-bit editions).
  • Android 6.0 or higher (tablet and phone).
  • iOS 10.0 or higher (iPad and iPhone).
Additional hardware
  • 1 GB RAM for Android and Windows.
Additional software
  • A third-party telephony or VoIP app such as Skype is required for placing calls from Business Central.
  • A third-party email program such as Outlook is required for sending emails from Business Central.
  • Microsoft Office 2019, Office 2016, or Office 365 is required for sending data to Microsoft Excel or to Microsoft Word.
Additional information
  • Device diagonal screen size 7' for tablets.
  • Screen resolution 960 × 510 for tablets.
  • Device diagonal screen size 4' for phones.
  • Screen resolution 854 x 480 for phones.

AL Development Requirements

The following table shows the minimum system requirements for customizing or extending Business Central using the AL language in Visual Studio Code.

Report Builder Download

Supported operating systems
  • Window Server 2016.
  • Windows 10 - supported versions.
Required software
Hardware resources
  • Hard disk space: 500 MB.
  • CPU: 4 cores minimum
  • Memory: 16 GB for development only.
    32 GB for developing and deploying locally.
    64 GB for developing large apps.

For more information, see Getting Started with AL.

Dynamics NAV Client connected to Business Central Requirements

The following table shows the minimum system requirements for using the Dynamics NAV Client connected to Business Central.

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (32-bit and 64-bit editions).
    Important: Windows 10 S is not supported.
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
Hardware resources
  • Hard disk space: 200 MB.
  • Memory: 1 GB.
Reports
  • For editing RDLC report layouts:
    • Report Builder for SQL Server 2016, or
    • Visual Studio 2017 with Microsoft Rdlc Report Designer for Visual Studio installed.
  • For editing Word layouts:
    • Microsoft Word 2016 or later
Outlook client integration and mail merge
  • Microsoft Office 365, Microsoft Office 2019, or Microsoft Office 2016.
Import and export with Microsoft Excel and Office XML, and SharePoint links
  • Microsoft Office 365, Microsoft Office 2019, or Microsoft Office 2016.
Editing in Excel using the Excel Add-in
  • Excel 2019 or Excel 2016.
    For more information, see Exporting Your Business Data to Excel. For Business Central on-premises, see Setting up the Excel Add-In for Editing Data since the same steps apply to Business Central on-premises.
Email logging
  • Active Directory and Microsoft Exchange Server 2019 or Exchange Server 2016.
  • Microsoft Exchange Online, or Exchange Online as part of an Office 365 subscription.
Additional software
  • Microsoft .NET Framework 4.7.2.
Additional information
  • Business Central Setup installs the following software if it is not already present in the target computer:
    • Microsoft .NET Framework 4.7.2.
  • The Dynamics NAV Client is available in a 32-bit version and 64-bit version. On a 32-bit Windows operating system, the 32-bit version is run. On a 64-bit Windows operating system, the 64-bit version is run by default; however, you can also run the 32-bit version if it is required.
  • Business Central Setup can only install the Excel Add-in if Excel is present on the target computer.
  • Outlook synchronization is not supported on 64-bit versions of Office.

Dynamics NAV Development Environment Requirements

The following table shows the minimum system requirements for the Dynamics NAV Development Environment.

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (32-bit and 64-bit editions).
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
Hardware resources
  • Hard disk space: 200 MB.
  • Memory: 1 GB.
Reports
  • For creating and editing RDL report layouts:
    • Report Builder for SQL Server 2016, or
    • Visual Studio 2017 with Microsoft Rdlc Report Designer for Visual Studio installed.
  • For creating and editing Word report layouts:
    • Word 2016 or later
Additional software
  • Microsoft .NET Framework 4.7.2.
Additional information
  • Business Central Setup installs the following software if it is not already present in the target computer:
    • Microsoft .NET Framework 4.7.2.
    • SQL Server Native Client 11.0.
    • Report Builder for SQL Server 2016. This is not installed if a version of SQL Server Report Builder or Microsoft Visual Studio is already present on the target computer
  • If the development environment and Business Central Server are on the same computer, then only a 64-bit operating system is supported.

Microsoft Sql Server 2016 Report Builder For Mac Free

Server Components (on-premises)

Business Central Server Requirements

The following table shows the minimum system requirements for Business Central Server .

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (64-bit edition).
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
.
Hardware resources
  • Hard disk space: 500 MB.
  • Memory: 2 GB.
Dynamics 365 for Sales integration
  • Windows Identity Framework.
    For a list of supported Dynamics 365 for Sales versions, see Microsoft Dynamics 365 for Sales Integration Requirements.
Additional software
  • Microsoft .NET Framework 4.7.2.
  • Windows PowerShell 4.0.
Additional information
  • Business Central Setup installs the following software if it is not already present on the target computer:
    • Microsoft .NET Framework 4.7.2.
    • Windows Identity Framework.

Business Central Web Server Components Requirements

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (64-bit edition).
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
.
Web server
  • Internet Information Server 10, Internet Information Server 8.5, or Internet Information Server 8.0.
Additional software
  • Microsoft .NET Framework 4.7.2.
  • Windows PowerShell 4.0.
Additional information
  • Business Central Setup installs the following software if it is not already present on the target computer.
    • Microsoft .NET Core 1.0 Windows Server Hosting. This is installed by Business Central Setup if not already present.
    • Microsoft .NET Framework 4.7.2.
    • Internet Information Server 10, Internet Information Server 8.5, or Internet Information Server 8.0, depending in the operating system, with the required features enabled.
  • For more information about configuring IIS, see Configuring IIS

Business Central Database Components for SQL Server Requirements

The following table shows the minimum system requirements for Business Central database components for SQL Server.

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (64-bit edition).
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
Hardware resourcesFor more information, see Hardware and Software Requirements for Installing SQL Server. From this page, you can also access requirements for other versions of SQL Server.
SQL Server
  • Microsoft SQL Server 2019 Express, Standard, or Enterprise.
  • Microsoft SQL Server 2017 Express, Standard or Enterprise.
  • Microsoft SQL Server 2016 Express, Standard or Enterprise.
  • Azure SQL Database Managed Instance, Elastic Pool, or Single Database.
Service Packs and Cumulative UpdatesUnless explicitly stated, all released Service Packs and Cumulative Updates of the above Microsoft SQL Server versions are supported. It is recommended to always be on the latest released Service Pack and Cumulative Update.
Additional informationBusiness Central Setup installs the following software if it is not already present on the target computer:
  • SQL Server 2016 Express (64-bit edition).
    If the operating system on the target computer does not support SQL Server 2016 Express, Setup displays a pre-requisite warning. In this case you should exit Setup and then update the operating system on the computer to one that does support SQL Server 2016 Express. Then run Setup again.

Business Central Help Server Requirements

The following table shows the minimum system requirements for the Business Central Help Server.

Supported operating systems
  • Windows 10 Pro, Enterprise, or Education (64-bit editions).
  • Windows Server 2019 Standard, Essentials, or Datacenter.
  • Windows Server 2016 Standard, Essentials, or Datacenter.
Hardware resource
  • Hard disk space: 500 MB.
  • Memory: 2 GB.
Web server
  • Internet Information Server 10, Internet Information Server 8.5, or Internet Information Server 8.0.
Additional software
  • Microsoft .NET Framework 4.7.2.
Additional information
  • Business Central Setup installs the following software if it is not already present on the target computer.
    • Microsoft .NET Framework 4.7.2.
    • Internet Information Server 10, Internet Information Server 8.5, or Internet Information Server 8.0. depending on the operating system, with the required features enabled.
  • Windows Search must be enabled on the computer that you install the Business Central Help Server on.

Additional Components and Features

Automated Data Capture System Requirements

The following table shows the minimum system requirements for Automated Data Capture System (ADCS) for Business Central.

Additional software
  • MSXML version 6.0.
  • Telnet or Microsoft Windows HyperTerminal.
  • VT100 Plug-in for each computer on which you install ADCS.
  • Microsoft Loopback Adapter.
Additional information
  • HyperTerminal is no longer included with Windows.
  • VT100 Plug-in acts as a virtual Telnet server.

Requirements for using Business Central on-premises as your Business Inbox in Microsoft Outlook

The following table shows the minimum system requirements for using Business Central on-premises as your business inbox in Outlook.

Supported Outlook Applications
  • Outlook 2016 or later
  • Outlook Web App
  • OWA for iPad
  • OWA for iPhone
  • OWA for Android.
Supported Exchange Servers
  • Exchange Online
  • Exchange Server 2019
  • Exchange Server 2016
    In deployments that use Exchange Server, the Exchange PowerShell endpoint must be accessible by Business Central Server.
Supported Authentication
  • The Business Central Server must be configured to run with NavUserPassword, ACS, or A<ure AD as the authentication type.
    Also, the Business Central Web client must be configured for Secure Sockets Layer (SSL).
Supported Browsers
  • When using the Outlook Web App (OWA), your computer must be running a supported browser listed in the Business Central Web client Requirements.
Supported Operating Systems
  • When using OWA for iPad, OWA for iPad, or OWA for Android, your mobile device must use a supported Operating System listed in Business Central Mobile App Requirements.

Microsoft Outlook Add-In Requirements

The following table shows the minimum system requirements for the Business Central Add-In for Outlook for synchronization with Outlook.

Supported Outlook Applications
  • Outlook 2019
  • Outlook 2016
Supported Exchange Servers
  • Exchange Server 2019
  • Exchange Server 2016
  • Exchange Online.

Microsoft Dynamics 365 for Sales Integration Requirements

The following table shows the product version requirements for integrating Business Central with Dynamics 365 for Sales, and the versions in which users can view the availability of items in Business Central from Dynamics 365 for Sales.

Microsoft Dynamics CRM versions
  • Microsoft Dynamics CRM 2015 or Microsoft Dynamics CRM 2016
    Note: AD, IFD and Claims authentication types are supported for above editions.
  • Microsoft Dynamics CRM Online 2015, Microsoft Dynamics CRM Online 2015 Update 1, or Microsoft Dynamics CRM Online 2016 Update 1 or Microsoft Dynamics 365
    Note: OAuth and Office 365 authentication types are supported for these editions.
For more details on authentication types, see Connection strings in XRM tooling to connect to Dynamics 365.
Business Central Integration Solution (.zip)For Dynamics CRM 2015, Dynamics CRM Online 2015, and Dynamics CRM Online 2015 Update 1:
  • Use the DynamicsNAVIntegrationSolution.zip file that is found on the Dynamics NAV 2016 installation media (DVD) to install the solution.
  • Item Availability is not supported on Dynamics CRM 2015, versions Update 1 and Online.
For more information, see Preparing Dynamics 365 for Sales for Integration.
Sales/Dynamics NAV/Business Central2015/Update 1/online2016/Update 1/onlineSales Enterprise (v8.x)Sales Enterprise and Sales Professional (v9.x)
Dynamics NAV 2016Supported ***Supported ***Supported ***Supported ***
Dynamics NAV 2017Supported **Supported *Supported *Supported *
Dynamics NAV 2018Supported **Supported *Supported *Supported *
Business Central (online)Not supported **Not supported **Supported *Supported *
Business Central (on-premises)Supported **Supported *Supported *Supported *

Legend:

Builder
  • '*' item availability capability is supported.
  • '**' integration solution can be installed from the Dynamics NAV 2016 DVD, but viewing item availability is not supported.
  • '***' viewing item availability is not supported

Note

AD, IFD and Claims authentication types are supported for the 2015 and 2016 on-premises versions of Dynamics 365 for Sales. OAuth and Office 365 authentication are supported for the 2015, 2015 Update 1, and 2016 Update 1 online versions of Dynamics 365 for Sales. For more details on authentication types, see Use connection strings in XRM tooling to connect to Dynamics 365 for Customer Engagement apps (on-premises).

See Also

Welcome to the Developer and IT-Pro Help for Business Central
Product and Architecture Overview
Deployment

-->

Report Builder is a tool for authoring paginated reports, for business users who prefer to work in a stand-alone environment instead of using Report Designer in Visual Studio / SSDT. When you design a paginated report, you're creating a report definition that specifies what data to retrieve, where to get it, and how to display it. When you run the report, the report processor takes the report definition you have specified, retrieves the data, and combines it with the report layout to generate the report. You can preview your report in Report Builder. Then publish your report to a Reporting Services report server in native mode or in SharePoint integrated mode (2016 and earlier).

You can also publish a paginated report to the Power BI service. Read more about paginated reports in Power BI Premium (Preview).

This paginated report features a matrix with row and column groups, sparklines, indicators, and a summary pie chart in the corner cell, accompanied by a map with two sets of geographic data represented by color and by circle size.

Jump-Start Report Creation

  • Start with a shared dataset. Shared datasets are queries based on a shared data source and saved to a Reporting Services report server in native mode or in SharePoint integrated mode.

  • Start with the Table, Matrix, or Chart wizard. Choose a data source connection, drag and drop fields to create a dataset query, select a layout and style, and customize your report.

  • Start with the Map wizard to create reports that display aggregated data against a geographic or geometric background. Map data can be spatial data from a Transact-SQL query or an Environmental Systems Research Institute, Inc. (ESRI) shapefile. You can also add a Microsoft Bing map tile background.

  • Start your report with report parts. Report parts are report items that have been published separately to a Reporting Services report server in native mode or in SharePoint integrated mode. Report parts can be reused in other reports. Report items such as tables, matrices, charts, and images can be published as report parts.

Design Your Report

  • Create paginated reports with table, matrix, chart, and free-form report layouts. Create table reports for column-based data, matrix reports (like cross-tab or PivotTable reports) for summarized data, chart reports for graphical data, and free-form reports for anything else. Reports can embed other reports and charts, together with lists, graphics, and controls for dynamic Web-based applications.

  • Report from a variety of data sources. Build reports using data from any data source type that has a Microsoft .NET Framework-managed data provider, OLE DB provider, or ODBC data source. You can create reports that use relational and multidimensional data from SQL Server and Analysis Services, Oracle, Hyperion, and other databases. You can use an XML data processing extension to retrieve data from any XML data source. You can use table-valued functions to design custom data sources.

  • Modify existing reports. By using Report Builder, you can customize and update reports that were created in SQL Server Data Tools (SSDT)Report Designer.

  • Modify your data by filtering, grouping, and sorting data, or by adding formulas or expressions.

  • Add charts, gauges, sparklines, and indicators to summarize data in a visual format, and present large volumes of aggregated information at a glance.

  • Add interactive features such as document maps, show/hide buttons, and drillthrough links to subreports and drillthrough reports. Use parameters and filters to filter data for customized views.

  • Embed or reference images and other resources, including external content.

Manage Your Report

  • Save the definition of the report to your computer or to the report server, where you can manage it and share it with others.

  • Choose a presentation format when you open the report, or after you open the report. You can select Web-oriented, page-oriented, and desktop application formats. Formats include HTML, MHTML, PDF, XML, CSV, TIFF, Word, and Excel.

  • Set up subscriptions. After you publish the report to the report server or a report server in SharePoint integrated mode, you can configure your report to run at a specific time, create a report history, and set up e-mail subscriptions.

  • Generate data feeds from your report by using the Reporting Services Atom rendering extension.

Note

Published reports are managed on a report server or a report server in SharePoint integrated mode by a report server administrator. Report server administrators can define security, set properties, and schedule operations such as report history and e-mail report delivery. They can create shared schedules and shared data sources and make them available for general use. Administrators also manage all of the report server folders. The ability to perform management tasks depends on user permissions.

See Also

What's New in SQL Server Reporting Services and Report Builder
Describes the new features in this version of Reporting Services and Report Builder.
Tutorial: Creating a Quick Chart Report Offline
Introduces Report Builder and the wizards available to help you create reports. The tutorial provides a set of data for you to work with so you do not need to connect to a data source to get started.

Planning a Report (Report Builder)
Provides information on what you should consider before you start to build your report.

Reporting Services Concepts (SSRS)
Defines key concepts used in throughout Report Builder documentation.

Report Design View (Report Builder)
Explains the different panes and regions of report design view.

Shared Dataset Design View (Report Builder)
Explains the different panes and regions of shared dataset design view.

Keyboard Shortcuts (Report Builder)
Outlines the shortcut keys available for navigating and designing reports in Report Builder.