March 1, 2010 at 9:50 am
Does anybody know how or if it's possible to control the name of the attachment in an email subscription? I know you can manipulate the file name in folder delivery and tried to modify the extension settings for an email delivery subscription (comparing an email and file delivery subscription). When I add </ParameterValue><ParameterValue><Name>FILENAME</Name><Value>Attachmentname</Value> to ReportServer.dbo.subscriptions.extensionsettings for my subscription I get The following error "setting is not valid: "FILENAME" " in my subscription status. Does anybody else know of a workaround? I have multiple subscriptions for one report and the attachment names all need to be different rather than the report name. I'd really like to not have to add multiple reports in reporting services just to be able to do this. Any help is appreciated.
March 16, 2010 at 9:00 am
Hi,
I don't think it is possible to dynamically change the report name for an email schedule.
The only possible workaround I can think of is to schedule the report to a file location
(It is possible to dynamically change the name of the report to file share) and then uses Integration Services to pick the relevant files from the share and send them to the relevant user.
I am not too familiar with integration services but I am pretty sure it will be able to pick the report from the file share and then maybe compare the report name to a table which holds the email addresses and send to the relevant user.
March 16, 2010 at 9:33 am
I would think you might be able to accomplish this by the use of a data driven subscription and a custom Delivery Extension. You can start with Custom delivery extensions here...
-Luke.
March 22, 2010 at 2:13 pm
Imagine that... here's an article from today's newsletter that details how to do this, better late than never.
http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69546/
-Luke.
March 23, 2010 at 6:33 am
Hey all, thanks for the support on this. Unfortunately I'm running SQL 2005 Standard edition so I cannot use data driven subscriptions. We've found a work around on this by renaming the reports on a daily basis. It's not optimal but it works for now.
Thanks again!
March 23, 2010 at 6:53 am
So just outta curiosity, another workaround that might be a bit more complex, but would allow you to not have to rename the report every day...
What about creating a subscription that writes to a fileshare, Then rename the file and email it? I'm thinking this could all be done with a single SSIS job, but my experience with creating them is limited. From a quick bit of googleing, you could schedule the report to create the file on the fileshare, then subscribe to it. The subscription will create a SQL Agent job. You can execute the SQL agent job from the SSIS package, then as the next step rename the file, then email it with the email task.
It's kinda the long way round, but it should be fairly robust and just work. Additionally, you can use the webservice task to call the report directly.
-Luke.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply