How to run the ssrs reports automatically at a specified time ?
Please help me how to run the ssrs reports automatically at a specified time ? Is that possible ?
Actually I need the SSRS report run automatically at a specified time and it should emailed to reciepients in a Excel format.
June 22nd, 2011 2:24pm
This is what subscriptions for.
http://msdn.microsoft.com/en-us/library/ms156307.aspx
Remember to mark as an answer if this post has helped you.
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 2:37pm
If you're using SSRS Enterprise Edition, you can use Data Driven Subscriptions
http://msdn.microsoft.com/en-us/library/ms159150.aspxJeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
June 23rd, 2011 1:52am
Can I schedule a Report to run automatically which has date parameter? Date parameter should take current date as a value.
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 5:52pm
Hi Guest,
Yes it can be possible to schedule the report to run automatically by providing date parameter.
Just provide Today() against date parameter under the subscription tab.
Amit
Please mark as answer if useful
July 9th, 2011 3:23pm