SQL Services Reporting Services - SSRS [Pros & Cons]

SQL Services Reporting Services - SSRS

• Pros
  • Flexibility in defining specific formatting and layout, specific item placement, multiple or composite report items, groups, headers, footers, subtotals
  • Report caching and snapshot for better performance especially if the source data query is complex and takes longer to execute
  • Creating report subscription for automatic report delivery via email or file share mode
  • Can combine multiple data sources (relational and OLAP data) into a single report
  • Additional charting options – map, area, range, scatter, polar, 3D, sparklines, data bars, etc
  • As similar as PPS dashboard, SSRS reports can also be deployed on a SharePoint site for collaboration
• Cons
  • Harder to create dashboards and therefore often done by IT people
  • No automatic drill-through and drill-across features