Following are the advantages of SQL Server Reporting Services (SSRS):-

• It is both quick and less expensive.
• It provides access to information stored in both MS SQL Server and Oracle DATABASES for efficient reporting.
• There is no need for high-priced specialised training to use SQL Server Reporting Services.
• Visual Studio.NET is integrated with the default report designer in SSRS. This allows us to create an application as well as reports in the same place.
• Security is controlled by a role-based approach that may be applied to folders and reports.
• Users receive subscription-based reports automatically.
• Reports on relational and cube data can be produced more quickly.
• It provides real-time data pertaining to the business, allowing for better decision-making.

Following are the disadvantages of SQL Server Reporting Services (SSRS):-

• There is no option to print. If you wish to print something, you must first export it to PDF, Excel, Word, or another format.
• If the report has PARAMETERS, users must need to pass the values for parameters even if they do not wish the data in the report to be filtered.
• Making changes to custom code and debug expressions is tough.
• It is not possible to include a page number or the TOTAL number of PAGES in the report body.
• There is no way to send values from sub-reports to the main report.
• Every new page has an EXTRA space created by the page header.