Home > Home, SSRS > SSRS Windows File Share Subscription Add Timestamp in File Name

SSRS Windows File Share Subscription Add Timestamp in File Name

Requirement is to add timestamp appended with the file name during export through Windows File Share subscription.

First we will check windows file share subscription and its default behavior.

Create sample report and deploy on report server.

Open the report and go to properties then go to Subscriptions as shown in below screen:-


Click on the New Subscription shown in above screen.

After clicking on New Subscription below screen comes.


Above form replace the values as per your environment.

Delivered by : Select Windows File Share

File Name: Default Name comes which is same as report name.

Path: Provide the shared folder name

Render Format: Select required file format.

Provide the login details and then select the Schedule and give appropriate schedule as per the requirement.

Click ok , Now subscription is created and can be seen in the subscription list as shown in given screen:-



Once the subscription is triggered and finished successfully the message it shows like below screen:-


Now we will check  the file in the shared folder, we can see file is exported and saved in the shared folder as shown below:-


We notice in default behavior there is no timestamp attached with the file name.

Now we will modify the subscription form and add timestamp.

To add timestamp add @timestamp in the file name as shown below screen:-


After adding @timestamp, just set the schedule and save it and wait for subscription trigger. once subscription triggered the status is changed where we can see the timestamp in the file name as shown below screen:-


Now we will check in the shared folder where the exported file get saved.

File with timestamp

As above screen contain new file with timestamp appended with file name.



Learn Different BI Tools
Subscribe my YouTube Channel : Know BI Tools



Categories: Home, SSRS Tags:
  1. Vinod Jain
    March 25, 2016 at 10:22 pm

    Simple and awesome technique! Thanks for your post Prasad 😀👍

  2. Christopher McNeil
    March 30, 2017 at 12:56 am

    This is great! Can you tell me if there is a way to do this for an E-Mail subscription?

    • March 30, 2017 at 7:19 am

      You can do using data driven subscription. In data driven subscription use the below query.

      Select ‘FileName’ + cast(getdate() as varchar) as filename

      Use above query filename field as filename in the data driven subscription setup.


  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: