File Share Delivery in Reporting Services
Reporting Services includes a file share delivery extension so that you can deliver a report to a folder. The file share delivery extension is available by default and requires no additional configuration.
To distribute a report to a file share, you define either a standard subscription or a data-driven subscription. You can subscribe to and request delivery for only one report at a time. For more information about working with subscriptions, see Creating, Modifying, and Deleting Subscriptions. For more information about defining a file delivery, see How to create a file share subscription.
You must specify an existing folder as the target folder. The report server does not create folders on the file system. The file share location must be specified in Uniform Naming Convention (UNC) format that includes the computer's network name. Do not include trailing backslashes. The following example illustrates a UNC path:
Reports can be rendered in a variety of file formats, such as HTML or Excel. The rendering format that you select for the subscription is used to save the report in a specific file format. For example, choosing Excel saves the report as a Microsoft Excel file. Although you can choose from any supported rendering format, some formats work better than others when rendering to a file. For more information, see Choosing Report Presentation Formats in a Subscription.
Unlike reports that are hosted and managed by a report server, reports that are delivered to a file are static documents. The file type is the application format that corresponds to the rendering format selected for the subscription. Interactive features that are defined for the report are represented as static elements in a file. A matrix report shows the top-level view of the report; you cannot expand rows and columns to view supporting data. If the report includes charts, the default presentation is used. If the report links through to another report, the link is rendered as static text.