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 filenamefrom 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

There' s another simple solution: Just add @timestamp behind the Filename in the Textbox. Example: myreport@timestamp The report will be saved with the Timestamp of the creation time.

Thanks you Daniel. Can I have list of global variables we can use like @timestamp?

This was a perfect fix for us, thx. We needed to use this on SQL 2008 Reporting Services Manager, worked like a charm!