To do the Report Builder tutorials, you need to be able to view and save SQL Server 2016 Reporting Services (SSRS) paginated reports on a report server or SharePoint site that is integrated with a report server. For data, all tutorials use literal queries that must be processed by an instance of SQL Server.
If you do not have access to a report server or site or to a data source, you can learn about Report Builder by building an offline report. See Tutorial: Create a Quick Chart Report Offline (Report Builder).
You must have the following prerequisites to complete Report Builder tutorials:
Access to Report Builder. You can run Report Builder from a Reporting Services report server or a Reporting Services report server in SharePoint integrated mode. Only the first step, how to open Report Builder, is different on the different servers.
On a report server, select New > Paginated Report.
On a report server in SharePoint integrated mode, on the Documents tab, select New Document, and from the drop-down list, select Report Builder Report. For example,
http://<servername>/sites/mySite/reports. The SharePoint administrator must enable the Report Builder Report feature for each document library.
The URL to a Reporting Services report server or a SharePoint site that is integrated with a Reporting Services report server. You must have permission to save and view reports, shared data sources, shared datasets, report parts, and models. By default, the URL for a report server is
http://<servername>/reportserver. By default, the URL for a SharePoint site is
The name of a SQL Server instance and credentials sufficient for read-only access to any database. The dataset queries in the tutorials use literal data, but each query must be processed by a SQL Server instance to return the metadata that is required for a report dataset. For example, the following connection string specifies only a server:
data source=<servername>. You must have read access to the default database that is assigned to you by the system administrator who grants you permission to access the server. You can also specify a database, as shown in the following connection string:
data source=<servername>;initial catalog=<database>.
The Tutorial: Creating Drillthrough and Main Reports (Report Builder) tutorial requires access to the Contoso Sales cube. See the tutorial for more information.
The report server administrator must grant you the necessary permissions on the report server, configure Reporting Services folder locations, and configure Report Builder default options. For more information, see Install and Uninstall Report Builder.
More questions? Try asking the Reporting Services forum