sql server 2005 - Variables to input in file name for Reporting Services subscriptions -

Is there a list that lists all the variables, for the membership of the report from within SQL Server Management Studio Can I use in filenames? I currently use @timestamp in my file names, but would like to use other options or even remove parts of time stamp (for example, only date Use, not time). Unfortunately @timestamp is the only available variable format

@stestamp There are various functions, but nothing is simple, here is a thread which does not describe one (but only one) solution:

If that link goes away, then The recommendations were:

To resolve this issue, I suggest using data-driven subscriptions

Data-Driven Subscriptions provide a way to use dynamic subscription data that is obtained from the external data source at runtime. A data-driven subscription can also use static text and default values ​​that you specify when the subscription is defined. We can use data-driven subscriptions to do the following:

Distribute a report to an unstable list of customers. For example, to deliver a report across a large organization, Operated membership, where customers have to change from one month to another, or use other criteria that determine group membership from a group of existing users . Filter report output using report parameter values, which are retrieved at run time. Separate report output format and delivery options for each report delivery. .

In this case, we can define the filename with the timestamp in the database and then use the data-driven subscription to make the report accessible.

For more information about data-driven subscriptions, please see:

For SQL Server Reporting Services 2005:

SQL Server Reporting Services 2008 For: