Updated: May 5, 2016
Applies To: SQL Server 2016
When you design a Reporting Services report, you may want to view it before publishing it to a production environment. You can do this in several ways: by switching to Preview mode in Report Designer, by using the preview window in Report Designer, and by publishing the report to a report server in a test environment.
You can preview a report in Report Designer by clicking . This runs the report locally, using the same report processing and rendering functionality that is provided with the report server. The report that is displayed is an interactive image; you can select parameters, click links, view the document map, and expand and collapse hidden areas of the report. You can also export the report to any of the installed rendering formats.
Another way to preview a report is to run the report project in a debug configuration, for example, to debug custom assemblies that you write. The report is opened in your default browser. There are three ways to run a project:
By clicking Start Debugging on the Debug menu.
By clicking the Start button on the Visual Studio standard toolbar .
By pressing F5.
If you use a project configuration that builds the report but does not deploy it, the report that is specified in the StartItem property of the current configuration opens in a separate preview window. The preview window displays the report in the same way and has the same functionality as Preview mode.
If you wish to preview a particular report that is not the start item for the project, select a configuration that builds the report but does not deploy it (for example, the DebugLocal configuration), right-click the report, and then click Run. You must choose a configuration that does not deploy the report; otherwise, the report will be published to the report server instead of displayed locally in a preview window.
You can also test reports by publishing them to a test server, browse to the report and preview. Publishing a report to a test server is the same as publishing to a production server. For information about publishing a report, see Publishing Reports to a Report Server.