Click here to Skip to main content
14,843,683 members
Articles / Programming Languages / SQL
Technical Blog
Posted 4 Jun 2015

Tagged as

Stats

15.1K views
10 bookmarked

SSRS SQL Server Reporting Services- Subscriptions for Reports

Rate me:
Please Sign up or sign in to vote.
5.00/5 (5 votes)
4 Jun 2015Ms-PL1 min read
Tutorial on how to set up an email subscription for reports generated in SSRS (SQL Server Reporting Services). Step by step explanations with a lot of images.

It is time for a new guest blog post. The author is again my colleague – Kristina Bankova LinkedIn, who is a Quality Assurance Engineer at Telerik. She prepared a full tutorial for how to create subscriptions for reports in SQL Server Reporting Services (SSRS).

How to Create a Subscription

  1. Navigate to http://YourServerName/Reports/Pages/Folder.aspx
  2. Click at Report Name

  3. Navigate to Subscriptions and click New Subscription.

  4. Configure the email, the schedule and the subject for your subscription.

You could have different schedules in your reports – either a custom one for the subscription or a shared one.

How to See and Manage Your Subscriptions

You can see, edit and delete your subscriptions.

From My Subscriptions, you could see all your subscriptions for all reports.

How to Create a Shared Schedule

  1. Navigate to Site Settings
  2. Navigate to Schedules and click at New Schedule.

How to Setup the SSRS SMTP Server

  1. Create a remote connection to the server machine (The one with the installed SSRS).
  2. Open the Report Services Configuration Manager.

  3. Configure the email settings

On the following address, you can find Kristina Bankova’s first guest blog article about how to set up Test Cases Statistics with SSRS and TFS Data Warehouse.

So Far in the TFS API Series

1. Connect to TFS Team Project C# Code
2. Manage TFS Test Plans C# Code
3. Manage TFS Test Cases C# Code
4. Manage TFS Test Suites C# Code
5. TFS Associate Automated Test with Test Case C# Code
6. Test Cases Statistics with SSRS and TFS Data Warehouse
7. SSRS SQL Server Reporting Services- Subscriptions for Reports

 

If you enjoy my publications, feel free to SUBSCRIBE
Also, hit these share buttons. Thank you!

The post, SSRS SQL Server Reporting Services- Subscriptions for Reports appeared first on Automate The Planet.

License

This article, along with any associated source code and files, is licensed under The Microsoft Public License (Ms-PL)

Share

About the Author

Anton Angelov
CEO Automate The Planet
Bulgaria Bulgaria
CTO and Co-founder of Automate The Planet Ltd, inventor of BELLATRIX Test Automation Framework, author of "Design Patterns for High-Quality Automated Tests: High-Quality Test Attributes and Best Practices" in C# and Java. Nowadays, he leads a team of passionate engineers helping companies succeed with their test automation. Additionally, he consults companies and leads automated testing trainings, writes books, and gives conference talks. You can find him on LinkedIn every day.

Comments and Discussions

 
QuestionSSRS SubReport's Subreport not rendering in main report Pin
Member 1328673930-Jun-17 2:13
MemberMember 1328673930-Jun-17 2:13 
AnswerRe: SSRS SubReport's Subreport not rendering in main report Pin
Anton Angelov2-Jul-17 10:18
MemberAnton Angelov2-Jul-17 10:18 
I am not sure that I can help you but you can ask my colleague, you can find her contacts at the beginning of the article. Good luck! Smile | :)

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.