Breaking

Thursday, July 23, 2020

Advantages & Disadvantages of SSRS

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.

No comments:

Post a Comment