SSRS, Proclarity and Panorama - Comparison

Lets evaluate the following Reporting tools which io worked in my career.

1) SQL Server Reporting Services 2005

2) Proclarity

3) Panorama

All the above reporting tools now belong to Microsoft. Microsoft acquired Panorama and Proclairy. Both these tools provides add-in for SSRS.

Analytical Reporting Capability : All the above 3 reporting tools provides the ability to create reports out of OLAP cubes. But Panorama and Proclarity are kind of Analytical Reporting whereas SSRS provies formatted Canned reports. In Panorama and Proclaity, Users can very well play with the OLAP data - like slicing, dicing, Drill through etc. Whereas in SSRS a great deal of programming effort is needed in case of SSRS.

Formating : In SSRS, it is easier compared to panorama and proclarity

KPI and Dashboarding : Panorama and Proclarity have many features in terms of dashboarding and KPI. Whereas SSRS doesnt have KPI or Dashboard capability.

Delivery of Reports : Scheduling and email delivery of reports in SSRS is added advantage over Panorama and Proclarity.It is better to go for Proclarity or panorama if your business users need more analysis.

Comparing Panorama and Proclarity - Out of the two, Proclarity is easier to work with, since Panorama needs Java Applet or DHTML in the client system to view the reports. Now Proclaroty is integrated with Performance point server.