Export (0) Print
Expand All

Testing Reports

SQL Server 2000

Testing Reports

When you design a report, you may want to view it before publishing it to a production environment. You can do this in several ways: by using the preview tab of Report Designer, by using the preview window in Report Designer, and by publishing the report to a report server in a test environment.

The Preview Tab

You can preview a report in Report Designer by clicking the Preview tab. 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.

For more information about previewing reports, see the following topic:

The Preview Window

Another way to preview a report is to run the report project in a debug configuration. There are three ways to run a project:

  • By clicking Start on the Debug menu.
  • By clicking the Start button.
  • 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. This is how the DebugLocal configuration behaves. The preview window displays the report in the same way and has the same functionality as the Preview tab. For more information about project configurations, see Deploying Reports to a Production Environment.

Note  Before debugging a report, you must set a start item. To do this, in Solution Explorer, right-click the report project, click Properties, and then in StartItem, select the name of the report to display.

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, right-click the report, and then click Run. You must choose a configuration that does not deploy the report (for example, the DebugLocal configuration). If you choose a configuration that does deploy the report, the report will be published to the report server instead of displaying locally in a preview window.

Print Preview

When you first view a report on the Preview tab or in the preview window, the view of the report resembles a report produced by the HTML rendering extension. The preview is not HTML, but the layout and pagination of the report is similar to HTML output.

You can change the view to represent a printed report by switching to print preview mode. On the Preview tab or in the preview window, click the Print Preview button on the preview toolbar. The report will display as though it were on a physical page. This view resembles the output produced by the Image and PDF rendering extensions. The preview is not an image or PDF file, but the layout and pagination of the report is similar the output in those formats.

Publishing to a Test Server

You can also test reports by publishing them to a test server. Publishing a report to a test server is the same as publishing one to a production server. For information about publishing a report, see Deploying Reports to a Production Environment.

See Also

Debugging and Publishing Reports

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft