Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

Viewing Reports

Updated: 17 July 2006

This topic describes the ways that you can run a report, viewing options, and the effects of refresh operations on an open report. You can use Report Manager, SharePoint Web parts, or a browser to view reports that are published to a report server. All reports that open from the report server are placed in an HTML viewer that provides page navigation and other functionality that is useful for working with a report. To view reports that have been delivered to a shared folder, you can use the desktop application that corresponds to the file type created during report delivery.

Finding and Viewing Reports in Report Manager

Explains how to start Report Manager and run on-demand reports.

Finding and Viewing Reports with a Browser

Explains how to connect to and run a report directly from the report server.

Viewing and Managing Report Server Items from a SharePoint Site

If you configured a report server to run in SharePoint integrated mode, you can view and manage reports, models, and shared data sources from Windows SharePoint Services 3.0 or Office SharePoint Server 2007.

Viewing Reports with SharePoint 2.0 Web Parts

Explains how to configure SharePoint Web parts for exploring and viewing published reports.

Reports that you open from the report server render as HTML in an HTML viewer. The viewer includes a report toolbar that you can use to navigate through the pages in a report, zoom in or out, search for specific report content, and more. The following illustration shows the report toolbar within a Report Manager window. The report toolbar also appears in a browser window at the top of a report when you access reports through a URL.

Report toolbar in Report Manager

Reporting Services opens the report in HTML 3.2 or HTML 4.0 format depending on the format that the browser supports. Once you open a report, you can export it to other viewing formats, including desktop applications. The easiest way to select and run a report is to open Report Manager and then search for or navigate to the report that you want to view. For step-by-step instruction on how to open reports, see How to: Open and Close a Report (Report Manager).

You can refresh a report in three different ways.

Option Result

Refresh button on the browser window

Displays the report stored in the session cache. A session cache is created when a user opens a report. Reporting Services uses browser sessions to maintain a consistent viewing experience while a report is open.

Browser refresh button on report toolbar

When you click the Refresh button on the report toolbar, the report server reruns the query and updates report data if the report runs on-demand. If the report is cached or is a snapshot, Refresh displays the report stored in the report server database.

CTRL+F5 keyboard combination

Produces the same result as clicking the Refresh button on the report toolbar.

Reporting Services uses browser sessions to maintain consistency while viewing reports. Sessions are based on browser connections, not authenticated users. A new session is created each time a user opens a report in a new browser window. Once a browser session is established, you continue to work with the version of the report that was opened when the session began, even if the report is modified on the report server. For example, if you open a report at 11:00 P.M., and a report author republishes the same report at 11:01 P.M., your session will contain the version that you opened for the duration of the session.

If you refresh a report within the same session using the browser's Refresh button, the original session version of the report is displayed. If you refresh an on-demand report using the Refresh button on the report toolbar, the report is re-run and new data, if any, is displayed. Different refresh options produce different results. For more information, see Viewing Reports.

Session information is stored in the report server temporary database. The report server does not use ASP.NET session management. If you restart the server or perform a database recovery operation, session state is not restored. For more information about session management, see Identifying Execution State.

You can bypass browser viewing entirely and use a desktop application (such as Microsoft Excel) as your report viewer instead. To do this, define a subscription that specifies a desktop application format and a shared folder destination. The report server generates your report as an application file, appends a file extension, and saves the report as a file on your hard drive. You can then use Microsoft Excel (or another application) instead of a browser to view your report.

Change History

Release History

17 July 2006

New content:
  • About User Sessions.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.