March 19, 2007 at 6:33 pm
I e-mail a set of about 20 reports each month to our sales team. We want to fully automate these. Half of these reports are the same report with different a different sales rep parameter.
We discourage our people from using e-mail as a filing system. Consequently, they have to save attachments elsewhere before doing anything with them (otherwise changes are lost in the "temp file oblivion").
Currently, SSRS delivers the files with the same file name. Saving these files elsewhere becomes a problem, and changing each filename manually is too difficult. Can I customise the filename of a PDF attached to an e-mail subscription? It *must* have a dynamic date value (last month), and I want to format the date in "yymmdd". I don't have Ent Ed.
July 20, 2010 at 1:34 am
I have also been searching for a solution regarding this issue. I cant believe that MS SQL overlooked the fact that they needed to make it easier to insert values like @ItemDate, @Department etc into the file name of a Report File Subscription.
Epic FAIL for MS SQL! :w00t:
[font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
-----------------------------------------------------------------------------------------------------------------------[/font]
July 20, 2010 at 2:20 am
We have been searching for a solution to this problem as well.
I have read somewhere that a custom delivery extension needs to be created to enable you to have a custom filename but have no idea how to do this
SSRS allows you to have a dynamic file name when you select the windows file share option for a data driven subscription but you can't set it for the email option.
It is a bit annoying that such a basic feature has not been included.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply