Advantages of using 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 which 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 page number or total pages in the report body
- Does not offer any method to pass values form sub-reports to the main report
- Page header always creates extra spaces on every new page.
.gif)
0 Comments