Getting Started with Reporting - Reporting with Microsoft SQL Server 2012 - page 8

Scenario 5
You need to export your reports to Microsoft Word.
Solution : SSRS allows you to export to Microsoft Word, whereas Power View does
not. Power View in Excel 2013 exports to PDF, Excel, XML, HTML, and comma
delimited text file. In the SharePoint version of Power View, it can only export to
PowerPoint. With SSRS, you can export to PDF, Excel, XML, comma delimited text
file, TIFF image, HTML, and Microsoft Word formats.
Scenario 6
You want to create a report where you can perform a drill-down and drill-through of
various summaries of the data.
Solution : Drill-down allows you to go from a general view of the data to a more
specific one at the click of a mouse (for example, going from the sales of a state to
sales of the cities in that state). A drill-through action allows you to jump to another
report that is relevant to the data being analyzed in the current report, also at the
click of a mouse (that is, going from showing sales by state in a tabular form to sales
by state in a country map). In SSRS, a drill-through requires manually creating a
drill-through action in the main report and passing parameters to other reports,
which you must create. For drill-down, you must manually define the groups
and detail rows or columns and then hide them, which are then accessed with a
plus sign that the user clicks on. However, these can be time-consuming tasks that
require a lot of coding. In Power View, it is much easier: drill-down requires you to
create a hierarchy and add it to a report or create a matrix report and enable drilling
down on rows. There is no additional coding as drill-down support is performed
automatically; drilling down is just a matter of double-clicking on the row or column
you want to drill into. Drill-through is done in Power View by simply clicking on the
various chart types in the Switch Visualization section of the design ribbon and the
chart is automatically changed.
Scenario 7
You need to do a lot of chart formatting for you report.
Solution : SSRS allows you to have finely detailed control over many of the
individual elements in any chart you want to display. While in Power View, there is
a very limited number of customization options. So while it is much quicker to build
a chart in Power View than in SSRS, if you need a lot of customization for your chart,
SSRS is the tool to use.