--- title: "Reporting Services Tools | Microsoft Docs" ms.date: 06/06/2019 ms.prod: reporting-services ms.prod_service: "reporting-services-native" ms.technology: tools ms.topic: conceptual helpviewer_keywords: - "SSRS, tools" - "Reporting Services, tools" - "components [Reporting Services]" - "components [Reporting Services], about components" - "Reporting Services, components" - "SSRS, components" - "reports [Reporting Services], tools" - "SQL Server Reporting Services, components" - "SQL Server Reporting Services, tools" - "architecture [Reporting Services]" ms.assetid: 23d616e3-eb90-43fb-9b7a-869bd7e22e7b author: maggiesMSFT ms.author: maggies --- # Reporting Services Tools [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)] contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment. The tool set includes development tools, configuration and administration tools, and report viewing tools. This article gives a brief overview of each tool in [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)] and how it can be accessed. To find a tool right away, see [Tutorial: How to Locate and Start Reporting Services Tools (SSRS)](../../reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs.md). ## Tools for report authoring The following table lists the available tools for report authoring in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)]. |Tool|Description|How to access| |----------|-----------------|-------------------| |[!INCLUDE[SS_MobileReptPub_Long](../../includes/ss-mobilereptpub-long.md)]|With [!INCLUDE[SS_MobileReptPub_Short](../../includes/ss-mobilereptpub-short.md)], you can create mobile reports that dynamically adjust the content to fit your screen or browser window and scale well to any screen size.

Create mobile reports on a design surface with adjustable grid rows and columns, and flexible mobile report elements.

For more information, see [Create mobile reports with SQL Server Mobile Report Publisher](../../reporting-services/mobile-reports/create-mobile-reports-with-sql-server-mobile-report-publisher.md).|Download the [SQL Server Mobile Report Publisher](https://go.microsoft.com/fwlink/?LinkId=733527)| |[!INCLUDE[ssCrescent](../../includes/sscrescent-md.md)]|An interactive data exploration and visual presentation experience designed to let you create and interact with reports based on [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] tabular models.|[!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)] in SharePoint mode. Browser with Silverlight.| |Report Designer|Use this tool to design reports. Includes the following features:

Deploy to a native mode or SharePoint mode report server.

Hosted in [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)]

Report Data pane to organize data used in your report

Tabbed views for Design and Preview for interactive report design

Query designers to help specify which data to retrieve from data sources and that are associated with data source types in the [RSReportDesigner Configuration File](../../reporting-services/report-server/rsreportdesigner-configuration-file.md)

Expression editor with IntelliSense to build [!INCLUDE[vbprvb](../../includes/vbprvb-md.md)] expressions that customize report content and appearance

Supports custom report items and custom query designers



For more information, see [Reporting Services in SQL Server Data Tools (SSDT)](../../reporting-services/tools/reporting-services-in-sql-server-data-tools-ssdt.md).|[!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)]| |Report Builder|Use this tool to design reports. Includes the following features:

Deploy to a native mode or SharePoint mode report server.

[!INCLUDE[msCoName](../../includes/msconame-md.md)] Office-like authoring environment[!INCLUDE[SS_MobileReptPub_Long](../../includes/ss-mobilereptpub-long.md)]

Ability to save report items as report parts

A wizard for creating maps

Aggregates of aggregates

Enhanced support for expressions

Query designers to help specify which data to retrieve from a selection of built-in data sources types

For more information, see [Report Builder in SQL Server](../../reporting-services/report-builder/report-builder-in-sql-server-2016.md).|Download the [standalone version of Report Builder](https://go.microsoft.com/fwlink/?LinkID=219138)

Or open from web portal/SharePoint| ## Tools for Report Server administration A set of graphical and scripting tools are available for administering the report server in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)]. The tools that you use depend on the deployment mode of your report server. ### Native mode The following table lists the available tools for administering the report server that is deployed in native mode. |Tool|Description|How to access| |----------|-----------------|-------------------| |Reporting Services Configuration Manager|Use this tool to configure a Reporting Services installation. Available tasks include:

Configuring the Report Server service account.

Creating and configuring one or more Web service URL.

Configuring the web portal URL

Creating and configuring the report server database.

Configuring a scale-out deployment.

Backup, restoring, or replacing the symmetric key that is used to encrypt stored connection strings and credentials.

Configuring the unattended execution account.

Configuring Subscription settings.

Configuring an SMTP server for e-mail delivery.

Configuring the Power BI Service (cloud).

Note: The Reporting Services Configuration Manager does not help you manage report server content, enable additional features, or grant access to the server.

For more information, see [Reporting Services Configuration Manager (Native Mode)](../../reporting-services/install-windows/reporting-services-configuration-manager-native-mode.md).|Start menu| |SQL Server Management Studio|Use this tool to manage one or more report server instances in a single environment, including:

Managing both local and remote report server instances

Setting report server properties

Modifying role definitions

Turning off report server features you are not using

Managing jobs

Managing shared schedules|Start menu| |Rsconfig Utility|Use this tool to configure and manage a report server connection to the report server database. You can also use it to specify a user account to use for unattended report processing.

For more information, see [Report Server Command Prompt Utilities (SSRS)](../../reporting-services/tools/report-server-command-prompt-utilities-ssrs.md).|Command prompt| |Rskeymgmt Utility|Use this tool to:

Extract, restore, create, and delete the symmetric key used to encrypt report server data

Join report server instances in a scale-out deployment



For more information, see [Report Server Command Prompt Utilities (SSRS)](../../reporting-services/tools/report-server-command-prompt-utilities-ssrs.md).|Command prompt| |Windows Management Instrumentation (WMI) Classes|Use these classes to automate the configuration tasks in Reporting Services Configuration Manager without the need to use the graphical user interface.

For more information, see [Accessing the WMI Provider Programmatically](../../reporting-services/accessing-the-wmi-provider-programmatically.md).|Visual Basic script| ### SharePoint integrated mode In SharePoint mode, the Reporting Services is a service application in the SharePoint architecture, and is administered directly through SharePoint |Tool|Description|How to access| |----------|-----------------|-------------------| |SharePoint Central Administration|Use SharePoint Central Administration to create, query, and manage the shared service applications for [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)].

For more information, see [Configuration and Administration of a Report Server (Reporting Services SharePoint Mode)](../../reporting-services/report-server-sharepoint/configuration-and-administration-of-a-report-server.md).|Browser to the SharePoint site URL for Central Administration| |PowerShell Cmdlets|Use PowerShell cmdlets to create, query, and manage the shared service applications for [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)].

For more information, see [PowerShell cmdlets for Reporting Services SharePoint Mode](../../reporting-services/report-server-sharepoint/powershell-cmdlets-for-reporting-services-sharepoint-mode.md).|SharePoint 2010 Management Shell| ## Tools for report content management A set of graphical and scripting tools are available for managing content in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)]. The tools that you use depend on the deployment mode of your report server. |Tool|Description|How to access| |----------|-----------------|-------------------| |Report Server Web service URL|Use this tool to browse content in the report catalog in a generic item navigation page.

For more information, see [Report Server Web Service](../../reporting-services/report-server-web-service/report-server-web-service.md).|Browser| |Web Portal|**(Native mode only)** Use this tool to administer a single report server instance from a remote location over an HTTP connection. You can do the following:

View, search, print, and subscribe to reports.

Create, secure, and maintain the folder hierarchy to organize items on the server.

Configure role-based security that determines access to items and operations.

Configure report execution properties, report history, and report parameters.

Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source.

Set model item security to allow access to specific entities in the model, or map entities to predefined clickthrough reports that you create in advance.

Create shared schedules and shared data sources to make schedules and data source connections more manageable.

Create data-driven subscriptions that roll out reports to a large recipient list.

Create linked reports to reuse and repurpose an existing report in different ways.

Launch Report Builder to create reports that you can save and run on the report server. For more information, see [The web portal of a report server (SSRS Native Mode)](../../reporting-services/web-portal-ssrs-native-mode.md).| Browser |RS Utility|This tool is a script host that you can use to perform scripted operations. Use this tool to run [!INCLUDE[vbprvb](../../includes/vbprvb-md.md)] scripts that copy data between report server databases, publish reports, create items in a report server database, and more. For more information, see [Report Server Command Prompt Utilities (SSRS)](../../reporting-services/tools/report-server-command-prompt-utilities-ssrs.md).|Command prompt| ## See also [Reporting Services Report Server](../../reporting-services/report-server-sharepoint/reporting-services-report-server.md) [Reporting Services Concepts (SSRS)](../../reporting-services/reporting-services-concepts-ssrs.md) [What is SQL Server Reporting Services (SSRS)](../../reporting-services/create-deploy-and-manage-mobile-and-paginated-reports.md)