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
Good blog,Great experience for me by reading this article.
ReplyDeletecore java training in chennai
C++ programming course
c++ course fees
C and C++ institute
c c++ course
javascript course in chennai
Appium Training in Chennai
JMeter Training in Chennai
Excellent info, I really appreciate your work. Continue sharing more with latest updates.
ReplyDeleteEthical Hacking course in Chennai
Ethical Hacking Training Institute in Chennai
Hacking course in Chennai
ccna Training in Chennai
Salesforce course in Chennai
PHP Training in Chennai
Tally course in Chennai
Ethical Hacking course in OMR
Ethical Hacking course in Anna Nagar
Ethical Hacking course in Vadapalani
I really like your post. I found it very helpful. Please keep posting such kind of valuable post.
ReplyDeleteC++ Course in Delhi
it just really very useful post, so thanks for sharing this keep posting a informative post.
ReplyDeleteDigital Marketing Institute
Faballey
ecommerce website design
redbus ticket online booking
Digital Marketing Institute
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.
ReplyDeleteCyber Security Projects for Final Year
JavaScript Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai