SSRS - How To Create SSRS Report with DateTime By Using Standard Subscription In SQL Server Reporting Services


I got this requirement where I have to generate SSRS Report with DateTime. I could have set Data Driven Subscription but that can be lengthy process. We can generate Report with Datetime by using Standard Subscription in SSRS. Follow the below steps.


Step 1: 
Create a SSRS report if you don't have one;) I have created Customer Report as shown below

Fig 1: Customer Report to Set up SSRS Subscription

Step 2: 
Go the the report on which you want to create subscription as shown and Choose Subscribe
Fig 2: Configure SSRS Standard Subscription

Step 3: 
Provide the required information as shown below, 2nd step is important as we have @Timestamp at the end of report name.This is going to add DateTime at the end of our report name.

 Fig 3: Generate SQL Server Report with Date Time 

Step 4: 
Let the report run on schedule and check the folder to confirm if report is generated with date time. As we can see that the report is generated with Datetime successfully.
Fig 4: Standard Subscription Windows File Share


  1. I really like your post. I found it very helpful. Please keep posting such kind of valuable post.
    C++ Course in Delhi

  2. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

  3. Getting your own one of a kind computerized promoting and showcasing blog can assist you with separating yourself from others in the business and stand .blog comments service in 1$

  4. publicizing dependent on degree of profitability (ROI) guaranteeing the leads created are at a cost that bodes well and expands benefit levels.Stationary Design


  5. You write this post very carefully I think, which is easily understand to me. Not only this, other post is also good. As a newbie this info is really helpful for me. Thanks to you.
    Tally Training in Chennai
    Tally ERP 9 Training
    tally classes
    Tally Training institute in Chennai
    Tally course in Chennai