If you send a data driven subscription via email there seems to be no chance to influence the name of the attachment (of the included report). There is no field to pass the value as when you use a file system subscription (FILENAME). The sales manager at our client location refuses to open each Excel spreadsheet attachement in his email to find the sales region and then select "Save As" with this name for each of their 77 sales regions every month. Does anybody know a hint how to do this anyway? Best regards, Stefan

Hi Stefoon, Thanks for your question. From your description, I have two different understandings of the requirement. 1. 77 sales regions displayed in 77 reports, you would like the attachments of the reports have the same name as the sales regions. In this condition, by default, when the report subscripted with an attachment via email, the attachment has the same name as the report. Thus, I would suggest you modify the report name with the sales regions. 2. 77 sales regions displayed in one report, yet there are page breaks between the different sales regions, so actually 77 sales regions in 77 sheets, you would like the sheets’ names are the sales regions’ name rather than sheet1, sheet2…, and so on. In this condition, if the reporting services edition is SSRS 2008 R2, there is one new feature helps you reach the target, you can specify one field as the page name, besides, this filed should be one field that has the page break, here you can use the field which page breaks the 77 sales regions. For more information and detail steps about this new feature, please refer to: http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports. The lower releases of SSRS haven’t this feature. Based on my research, there is one workaround: you choose XML output, attach an XSLT, and create SSML instead of binary Excel. Please reference it: http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx. Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.