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

Scenario: 

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.

Solution: 

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



11 comments:

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

    ReplyDelete
  2. 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$

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

    ReplyDelete
  4. Step-by-Step create website Easy to Customize, Publish Now! Custom domain name. Multiple payment methods. Free multilingual fonts. 24/7 support center. 1000s of free images. Top industry hosting. 100s of Apps. Easy-to-add blog. Mobile optimized. Create Website

    ReplyDelete
  5. Step-by-Step create website Easy to Customize, Publish Now! Custom domain name. Multiple payment methods. Free multilingual fonts. 24/7 support center. 1000s of free images. Top industry hosting. 100s of Apps. Easy-to-add blog. Mobile optimized. Create Website

    ReplyDelete