• Home
  • SSRS
  • What is SSRS (SQL Server Reporting Services)

What is SSRS (SQL Server Reporting Services)

  • (4.0)
  • | 1998 Ratings

What is SSRS?

SQL Server Reporting Services is a reporting tool that comes free with SQL Server 2012. With SSRS you can produce formatted reports with tables of data, graphs, and charts. These reports are hosted on a server and they can be configured to run using parameters supplied by the user. When the report runs, it displays current data from the source database, XML file or other data source.

In addition to users running reports on-demand, reports can be scheduled to run at certain times or they can be published manually. Reports can be published to a web site, integrated into a Windows application or form part of a SharePoint site.

Learn how to use SSRS, from beginner basics to advanced techniques. Enroll for Free SSRS Training Demo!

This SSRS tutorial teaches the basics of designing reports, so to keep things simple, the reports will not be published to anywhere other than your local development machine.

Related Page: How To Access Report Manager In SSRS 2012

When might reports be useful?

Consider a medical research facility where patients are recruited on to various clinical trials. The staff in the clinic create a database record for each patient when he or she agrees to be part of the trial, and then clinic receives a payment from the drug company based on the rate at which it finds willing participants.

A typical scenario in the past might have involved the clinic emailing the drug company with the total number of participants in the trial on a weekly basis, maybe with details of any patient who dropped out of the trial for medical or personal reasons, the amount of drugs used, and any adverse events encountered. The time taken to collate and send this data in the correct format would take up valuable time in the clinic.

If the clinics were recording data in a database, SSRS could be used to produce ondemand reports in a pre-defined format that could then be either exported as a PDF, Excel, etc and emailed to the drug company, or the drug company could be given access to a reporting server so that they could run the report at any time, and get up-to-date data without anyone from the clinic lifting a finger.

Frequently Asked SSRS Interview Questions & Answers

List of Related Microsoft Certification Courses:

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter. Protection Status