1.

What is SSRS

Answer»

SSRS is an acronym for SQL Server Reporting Services. It is a free reporting tool from Microsoft that comes with SQL Server. It generates structured reports that include data tables, graphs, and reports. Reports are stored on a server and can be set up to run using user-supplied parameters. The current data from the database, XML file, or other data source APPEARS when we run the reports. It has security features that limit who has access to which reports. 

Consider the SSRS report of a medical research facility that recruits individuals for various clinical trials. For each patient, the institute's staff builds a database record. Once they agree to engage in the trial, the hospital is PAID by the pharmaceutical firm based on the price at which it is willing to participate. Without SSRS, the medical institute would have to manually email a report with the total NUMBER of weekly participants to the pharmaceutical business. The institute must also include information about each patient who participated in the experiment, the number of medications used, and any adverse events. As a result, the time it takes to collect and submit this information in the proper format COULD eat up a lot of time in the clinic. If the institute kept track of data, they could use the SSRS tool to generate on-demand reports in a pre-defined format. The drug business can retrieve the report on the cloud and run it at any time to acquire the most up-to-date data from the clinic using SSRS.



Discussion

No Comment Found

Related InterviewSolutions