View a report in another application format

Reporting Services provides interactive Web-based reports that you can access from a SharePoint site or export to another application. When you open a report from a SharePoint site, it opens in HTML. To view a report in another application, you can export it.

Exporting a report is an on-demand task that you perform when the report is open. However, if you want to always see a report in a particular application format, create a subscription that delivers the report to a library or to a shared folder. Within the subscription, you can specify output options so that the report is delivered as an application file to the location you specify.

What do you want to do?

Export a report to another format

View a list of supported formats

Export a report to another format

The report is exported using the data and layout that is current for the report. If a report author publishes an updated version of the report while you have it open, the updated version is ignored.

  1. Open the report.

  2. On the Actions menu of the report toolbar, point to Export. If the report toolbar is not visible, it has been hidden and you cannot use the functionality it provides.

  3. Select an application format. The report opens in the associated application. The file associations defined for the local computer determine which application is used for a particular output format.

Note: Not all application formats work well for every report. In some cases, a report author might have designed a report with a particular format in mind. If you choose a different format, the appearance or behavior of the report might be different from what you expect. For example, for large reports that span multiple pages, you can expect to see different pagination when you export the report to another format. Similarly, reports that include visual content or interactive features (such as hyperlinks, or areas that expand and collapse) might not have those features in the exported report.

Top of Page

View a list of supported formats

The application formats that you can export to are associated with rendering extensions that are installed on the report server, and then made available through configuration settings. Application formats can vary from one report or report server installation to the next. For example, a report server administrator can add or remove rendering extensions from configuration files, determining which export formats are available from the drop-down list, or specify device information settings that override default rendering behavior. Similarly, a developer can set URL parameters that render the report in a specific output format, or that hide a report toolbar from a report, preventing the use of the export option and other toolbar features.

The following table shows the application formats that are typically available on most report servers.

XML

Opens a report in XML. The report opens in a browser.

Use this format to copy report data from a report server to other applications or servers.

CSV

Opens a report in comma-delimited format. The report opens in an application associated with CSV file formats.

This format produces the smallest file size. Use this format to copy report data from a report server to other applications or servers.

TIFF

Opens a report in a page-oriented format. The version of the Windows operating system determines which application is used.

Use this format to print paginated reports. This format is useful if you don't have Acrobat Reader installed.

Acrobat (PDF) file

Opens a report in Adobe Acrobat Reader (version 6.0 or later).

Use this format to print paginated reports or to create PDF versions of a report.

Web archive

Opens a report in MHTML. The report opens in Internet Explorer. This is the default rendering format for Internet Explorer 6.0.

In contrast with other HTML rendering extensions, the Web archive format produces a self-contained, portable report (embeds images within the report). Use this format to view HTML reports offline or for e-mail-based delivery.

Excel

Opens a report in Microsoft Excel.

Use this format to manipulate report data in Microsoft Excel 2000 or later. The Excel export format renders the report in the native binary format (BIFF).

Performance and memory consumption varies for each application format. The same report will render at different rates and require different amounts of memory depending on the format you select. The fastest and least memory-intensive formats are CSV, XML, and HTML. PDF and Excel have the lowest performance but for different reasons. PDF is CPU-intensive, while Excel is RAM-intensive.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×