Can I control the filename of an email attachment delivered from SSRS?

[Kevin Frey]

Hello,

We have a subscription set up in SSRS to execute a report weekly and deliver
it via email as an attachment. The name of the attachment is currently the
same as the name of the report that it is generated from, plus an
appropriate extension.

The customer receiving this attachment has asked whether we can change the
name of the file. Furthermore, change the name of the file to be dynamic
based on the date when the report is generated.

For example, DATA_20090710.csv, meaning the data was generated on 2009/07/10
for example.

Does anyone know if this is possible to do, and how to do it?

Thanks

Kevin

[jammy]

yes you can add date paramenter like @datetime to file name

e.g file...@datetime.xls

url:http://www.ureader.com/msg/115716962.aspx

[Randy]

I tried @datetime and it didn't work.
BOL has it as @timestamp, and that works.