Microsoft SQL Server 2005 Reporting Services
| SSRS comes bundled with two main delivery extensions: email and file share. Although skilled developers can implement their only delivery extensions, the prepackaged ones should suffice for most people.
Email can be used to deliver reports , or it can be used to deliver a hyperlink to the generated report; the contents of the message are based on the data included with the subscription. The Subject line contains, by default, the Report Name ( @ReportName ) and the time it was run ( @ExecutionTime ). Of course, the user can modify this to suit her needs. The body text can contain an embedded report or the report can come as an attachment. This depends on the rendering extension used. The HTML and MHTML extensions embed the report in the email body. All other extensions generate an attachment to the message. The email extension is not available if the Report Server has not been set up for email. To set up email, use the Reporting Services Configuration Tool. From the RS Configuration Manager, select Email Settings and then enter the sender address and name of the SMTP server. The size limitations of email apply to subscribed reports as well. If the report is delivered as an attachment and the size of the attachment is too large, the report might not get delivered. Second, the Report Server does not validate the email addresses entered when creating the subscription or during runtime in the case of data-driven subscriptions. Delivering to a File Share
The file share delivery extension drops rendered reports to a specified file share. The extension does not create a folder; however, it does drop files into any standard UNC share. As with any file share, the account that the Report Server service is running under must have access to the share to write to it successfully. The naming format for a UNC share is as follows :
\<servername>\<sharename>
Remember not to include a trailing backslash. After the report is rendered, a file is created using the specified delivery extension. For example, if the delivery extension specified is PDF, a PDF file is created on the file share. Because a file is fairly static, an interactive feature in the rendered reports is made static. Hence, things like matrixes and charts will retain the default views. |