Advantages of using SSRS

SSRS

It is faster and cheaper.
Efficient reporting access to information that is residing in both MS SQL Server database or Oracle
No need for expensive specialist skills
In SSRS the default report designer is integrated with Visual Studio. NET. This allows us to create an application and reports in the same environment.
The security is managed in a role-based method that can be applied to folders and reports.
Subscription-based reports are automatically sent to the users.
Faster production of reports on both relational and cube data
Real-time information to the business, providing better decision support

Disadvantages of using SSRS

Some limitations of SSRS are given below:

There is no print button. So if you want to print something you need to export PDF, excel, word, or other formats.
All reports need parameters to be accepted by users.
It is difficult to make changes in the custom code and debug expressions.
Does not allow you to add the page number or total pages in the report body
Does not offer any method to pass values from subreports to the main report
Page header always creates extra spaces on every new page.