Variables to input in file name for Reporting Services subscriptions

Question

Is there a list anywhere that lists all the variables I can use in file names for report subscriptions from within SQL Server Management Studio? I currently use @timestamp in my file names, but would like to use other options or even remove parts of the time stamp (for example, just use the date, not the time).

Answer 1

Unfortunately @timestamp is the only variable available. There are various workarounds for formatting @timestamp, but nothing that is simple. Here is a thread that explains one (but not the only) workaround: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/81f47009-946a-4ebc-be43-7690236e829b