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

SubscriptionProperty

Click on the New Subscription shown in above screen.

After clicking on New Subscription below screen comes.

SubscriptionForm

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

Subscriptionlist

 

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

SubscriptionStatus

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

FileExported

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

Timestamp

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

SubscriptionStatus_1

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.

Thanks

Prasad

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

 

 

Advertisements
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.

      Thanks
      Prasad

  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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: