Database Reference
In-Depth Information
• The current implementation of Power View requires the installation of a
Silverlight browser plugin. This can add complications that you generally
don't have with SSRS because it does not require any browser plugins. In
addition, Silverlight is a dying technology and is being replaced with HTML
5 (Microsoft is working on a HTML 5 Power View client).
• Power View in SharePoint requires SharePoint Enterprise and the installation
of Reporting Services in SharePoint Integrated mode. SSRS will work with
the Standard edition of SharePoint and has a Native mode that does not
require SharePoint. Power View also works with Excel 2013 (ProPlus edition
only), but many companies have not yet upgraded to it and are still using
Excel 2010. Additionally, if you are using Excel 2013, it is likely that you still
want to use SharePoint Enterprise to share the reports instead of sharing
the workbook.
• Power View does not support the passing of parameters, whereas SSRS does.
• Power View does not have any means of scheduling reports or automatic
report delivery. On the other hand, SSRS has a sophisticated way of
scheduling and delivering reports using subscriptions.
• Power View does not support custom code, so there is no way to extend its
features. SSRS is very flexible in allowing you to extend its code, so you can
do just about anything with it.
Reporting scenarios
Which is the best reporting tool for the job? The following are various reporting
scenarios you may encounter and our suggestions on the best tool to use along
with the reasons why:
Scenario 1
You want the reports to be created automatically and delivered via e-mail to certain
users every morning. For such reports, you will pass in certain parameters such as
country codes and the beginning and ending dates.
Solution : Since Power View does not support scheduled rendering and delivery of
reports or parameter passing, SSRS is the reporting tool to use in this situation. In
fact, this is what SSRS excels at thanks to the sophisticated subscription feature. This
feature allows you to register with a publisher to get any report on a scheduled/
reoccurring basis. A subscription includes parameters and a recipient list, rendering
format, delivery schedule, and delivery method.
 
Search WWH ::




Custom Search