Thursday 18 April 2013

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