Following are the difference between SQL Server Reporting Services (SSRS)
and Performance Point Server (PPS)
and Performance Point Server (PPS)
- SSRS as
well as PPS both has sufficient set of Indicators that required for any
report including Scorecard & Dashboard. - Report
Performance will be good if we go with SSRS if application DB & Report
server DB will be in same SQL Server instance. For SharePoint, we need to
configure Business data connectivity services in the SharePoint that won’t
be faster that SSRS instance. - PPS will
be preferable if we have to show dynamic reports e.g we can change a
tabular report to Chart etc on report itself. SSRS is good for canned reports. - Following
are the few formatting issue with PPS 2007: - Cannot do custom labelling.
- Cannot increase custom width
- Cannot get grand totals
- Cannot get subtotals
- Adding
KPIs in SSRS is easier as compare to PPS. - In PPS,
colors/fonts in data cells cannot be changed. But in SSRS, each cell can
be altered in terms of colors and number formats. - SSRS
report will take 2-5 mins or more to generate the report if it has bulk
data. - In SSRS,
each sub-report (popup report) will be a separate report (rdl) that will
reference the main report. - In SSRS,
Drilldown will be slightly slow if we have bulk data on report compared to
PPS - Maintenance
of SSRS instance is easier than maintaining SharePoint Server. - By using
Caching & Report Snapshot, we can achieve a good performance in SSRS.