My company sends reports on a daily basis to our customers. Now I want to save all the sent reports on disc with the date in the filename. I have set up a subscription which daily saves the files where I want them. However, I haven't found a way to add the date easily. I already have a parameter when creating the report, it is called Date. Does anybody know if I can use a parameter or something else?
Thank's
Hello,
Sorry, I don't believe there is a way to modify the filename from a subscription, but you can specify a filename from a Data-Driven Subscription. Do a data-driven subscription to a file share, and just include an extra column in your subscription query to have something like this:
select 'Report or file name here ' + convert(varchar, getdate(), 101) as FileName, ...
Then, when you are setting the delivery extension settings, use this field as your File name.
Hope this helps.
Jarret
