Redigera

Dela via


Find, view, and manage reports (Report Builder and SSRS)

In Report Builder, you can browse folders on a report server or SharePoint site to find paginated reports, shared data sources, models, and other related report items. You can also browse your computer to find local reports. To make it easier to find reports, Report Builder maintains a list of recently used servers and sites and provides direct access to the Desktop, My Documents, and My Computer folders in the file system of your computer.

In Report Designer, you can also browse your computer to find local paginated reports. After you deploy reports to a report server or SharePoint site, you can browse the report server by using the web portal, or search the SharePoint site to find reports. Reports and related items remain available locally after they're deployed.

Note

You can use Report Builder in local mode or connected to a report server. Certain limitations apply when you don't have an active connection to a report server.

To locate a report on a report server or SharePoint site from Report Builder, you must provide the URL to the report server or SharePoint site. When you first install Report Builder, you can specify the URL to use. This URL is the server or site that Report Builder connects to by default when you save or open reports.

You can preview reports in Report Builder and Report Designer when you create or update reports. You can also view and manage reports on a report server. You can manage them by using the web portal or on a SharePoint site that's integrated with Reporting Services. For more information, see Preview reports in Report Builder and Preview Reports in SQL Server Reporting Services (SSRS).

When you preview reports in Report Builder and Report Designer, or view reports in the web portal or a SharePoint site, the data is refreshed. The reports then display the current data from the data source that the report uses. If you want to view a report without refreshing its data, you can use report history and cached data with published reports. You can't use these features when previewing reports in Report Builder and Report Designer.

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

Find and view reports in Report Builder

To find a report that you want to work with, browse your computer, folders on a report server, or SharePoint site integrated with Reporting Services. Additionally, you can select a shared data source, image, or subreport to use in a report.

To find reports on a report server, you must specify a URL for the report server and have the appropriate permissions on the folders that enable you to read and save report items. Ask the system administrator for the report server for the appropriate URL and permissions.

After you find and open the report in Report Builder, you can preview it and make changes. When you preview it, you see the current data. For more information, see Preview reports in Report Builder.

Report Builder can help you with the following tasks:

  • Find reports: When you browse for a report, you can use the familiar Microsoft Office-style Open File dialog that's customized for Report Builder. You can browse the folders on a report server or on a file system, including My Reports, Sites and Servers, Desktop, My Documents, and My Computer. Sites and Servers provide a recently used server list.

  • Find shared data sources: When you browse for a shared data source, you can pick from a recently used list, or browse to another folder on the same report server as the report.

  • View reports: You preview a report in Report Builder when creating or updating reports. When Report Builder is connected to a report server, the report server loads and processes the report. Otherwise, the reports are processed locally. The report viewer in Report Builder displays the rendered report.

View and manage reports on a report server

You use the web portal to view and manage reports on the report server. Browse the folders on the server to locate reports, run reports, view them in a browser, and perform management tasks.

The web portal can help you with the following management tasks:

  • View and update the properties of reports, shared data sources, and other report items.

  • Upload reports and create new shared data sources for reports.

  • Create schedules to run reports at specified times and intervals.

  • Create, change, or delete subscriptions to reports.

  • Create report history and specify the number of report snapshots to keep in the report history.

  • Create new folders on the server to organize your reports the way you want.

Some of these tasks might be done for you by the administrator of the report server. To learn more about tasks performed on a report server, see Reporting Services report server (native mode).

The web portal typically contains folders, reports, data sources, and the My Reports folder. My Reports is a personal workspace that you can use to store and work with reports that you own. Other report server folders are public and typically require users to have advanced permissions to add to or modify folder contents. You can create subfolders within My Reports to further organize your reports.

The web portal displays reports in the Reporting Services HTML Viewer. The HTML Viewer provides a framework for viewing reports in HTML and includes a report toolbar, a parameter section, a credentials section, and a document map. The report toolbar provides page navigation, zoom, refresh, search, export, print, and data feed functionality. The report toolbar also appears in a browser window at the top of a report when you access reports through a URL. Print functionality is optional and your administrator must turn it on. When it's available, a printer icon appears on the report toolbar. The following illustration shows a closeup of the report toolbar in the web portal.

Screenshot of the Report toolbar in the web portal.

After you run a report, you can export it to another format, such as Microsoft Excel or PDF. You can also export the report using a data rendering extension such as the Comma-Separated Value (CSV) rendering extension and then use the CSV data file as input to another application. For more information about exporting reports, see Export paginated reports (Report Builder).

The easiest way to select and run a report is to open the web portal and then search for or browse to the report that you want to view.

After you run a report, you can refresh it to see new data.

Refresh reports

Report data frequently changes, and you might want to refresh the report to view the newest data. 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.
Screenshot of the browser Refresh button on report toolbar. When you select 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, the refresh action displays the report that's stored in the report server database.
CTRL+F5 keyboard combination Produces the same result as selecting the Refresh button on the report toolbar.

View and manage report server items from a SharePoint site

When the system administrator configures a report server to run in SharePoint integrated mode, you can view and manage reports and other report server items from a SharePoint site.

The SharePoint site includes pages to configure schedules, subscriptions, report parameters, data source properties, and report processing options; to view report history; and to create shared schedules. You can manage report server items on a SharePoint site the same way you create and manage them from other tools in SQL Server.

To access the application pages, select item-specific actions from a list menu on a report or other report server item that you previously added to a SharePoint library. Depending on the item and your permissions, you might also be able to create reports in Report Builder, generate models, and set model item security.

For more information about Reporting Services and SharePoint technology, see Configuration and administration of a SQL Server Reporting Services (SSRS) report server.

Find report server items on a SharePoint site

Before you can set properties, you must first be able to locate the item. Report server items are always stored in libraries or in a folder within a library.

When you access the SharePoint site, you see the Browse page and the Library Tools tab. The Browse page lists the libraries and the content of the selected library. You can view the report and other items in the library, explore folders, and search the site to locate items.

To distinguish report server items from other items on a SharePoint site, you can use the icon to visually identify an item, or pause the mouse cursor over the type and read the file extension. The following image shows folders and a report definition in the Reports library:

Screenshot of the Sharepoint library with report server items.

View reports

Report definitions (.rdl files) that you upload to a SharePoint library are viewed through a Report Viewer web part that the Reporting Services add-in installs. An .rdl file association is defined automatically when you install the add-in.

When you select a report, it opens automatically in the web part. After the report is open, you can use the report toolbar that's included in the web part to navigate pages, search, zoom, and print the report. The toolbar includes the Export Data Feed option to export the report as an Atom data feed and an Actions menu with options to print, subscribe, and export the report to different formats such as PDF, Word, and Excel.

From the Actions menu, you can also open the report in Report Builder. The following image shows a report and the options of the Export options on the Action menu.

Screenshot of the Export options in the Action menu.

Manage items through actions

Management tasks are supported through actions on a dropdown menu for each item. Depending on your permissions, each item has common actions that are standard for items that are stored in a SharePoint library. View Properties and Edit Properties are examples of common actions. Custom actions provide item-specific management functionality. The following image shows the actions for a report definition. Examples of custom actions for a report definition include Manage Subscriptions and Manage Processing Options.

Screenshot of the menu commands for report server items.

View reports in a desktop application

You can bypass browser viewing entirely and use a desktop application, such as Microsoft Excel, as your report viewer instead. To bypass the browser viewing, 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 name extension, and saves the report as a file on your hard disk. You can then use Microsoft Excel (or another application) instead of a browser to view your report.

About user sessions

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 every time that a user opens a report in a new browser window. When a browser session is established, you continue to work with the version of the report that was opened when the session began. You can continue even if the report is modified on the report server. For example, say you opened a report at 11:00 P.M., and a report author republishes the same report at 11:01 P.M.. Your session then contains the version that you opened during the session. This result means you don't automatically see the changes made in the republished version until you refresh or reopen the report.

If you refresh a report within the same session by using the browser's Refresh button, the original session version of the report is displayed. If you refresh an on-demand report by using the Refresh button on the report toolbar, the report is rerun and new data, if any, is displayed.

Session information is stored in the report server temporary database. The report server doesn't use ASP.NET session management. If you restart the server or perform a database recovery operation, session state isn't restored.

For more information about session management, see Identify the execution state.