Exporting to an Image File (Report Builder and SSRS)


Applies To: SQL Server 2016

The Image rendering extension renders a paginated report to a bitmap or metafile. By default, the Image rendering extension produces a TIFF file of the report, which can be viewed in multiple pages. When the client receives the image, it can be displayed in an image viewer and printed. This topic provides Image renderer-specific information and describes exceptions to the rendering rules.

The Image rendering extension can generate files in any of the formats supported by GDI+: BMP, EMF, EMFPlus, GIF, JPEG, PNG, and TIFF. For TIFF format, the file name of the primary stream is ReportName.tif. For all other formats, which render as a single page per file, the file name is ReportName_Page.ext where. ext is the file extension for the chosen format. To produce a file in another Image-supported format, specify any of the above listed strings in the OutputFormatDeviceInfo setting.

System_CAPS_ICON_note.jpg Note

You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

The following table shows the file extension and MimeType for each Image renderer format.


Arrow icon used with Back to Top link Back to Top

TIFF is the only format that supports multiple page documents in a single file. Other formats, such as JPG or PNG, output one page at a time and require a separate call to the rendering extension for each page.

Arrow icon used with Back to Top link Back to Top

Interactivity is not supported in any Image formats generated by this renderer. The following interactive elements are not rendered:

  • Hyperlinks

  • Show or Hide

  • Document Map

  • Drillthrough or clickthrough links

  • End user sort

  • Fixed headers

  • Bookmarks

Arrow icon used with Back to Top link Back to Top

You can change some default settings for this renderer by changing the device information settings. For more information, see Image Device Information Settings.

Arrow icon used with Back to Top link Back to Top

Pagination in Reporting Services (Report Builder and SSRS)
Rendering Behaviors (Report Builder and SSRS)
Interactive Functionality for Different Report Rendering Extensions (Report Builder and SSRS)
Rendering Report Items (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)

Community Additions