Database Reference
In-Depth Information
There are two types of subscriptions: standard subscription and data-driven
subscription. With a standard subscription, report parameters are provided at the
time of subscription and cannot be changed at runtime. A data-driven subscription
allows parameter values to be returned from a query during the execution of
the report.
Scenario 2
You need to create a report but are not sure what you want it to look like. Also,
you want to explore the data and build a report on the fly.
Solution
: Power View is ideal for users who don't know up front how they will
combine and analyze the data. Moreover, they don't know what question to ask.
Instead, they want to discover the meaning in the data and slice and dice the data.
Power View's main purpose is just that type of ad hoc situation, whereas SSRS
requires you to have a clear idea of what the report should look like and what
data should be used.
Scenario 3
You need to create a simple report quickly.
Solution
: While SSRS was originally created for technical users (developers), it
has evolved into a more self-service tool for power business users. However, it still
has a steep learning curve. On the other hand, Power View is very easy to use and
extremely intuitive. Although you may sacrifice certain features by using Power
View, you can generate a report very quickly, even if you have never used Power
View before.
Scenario 4
You want to generate a report that has a list of all the orders from the last week.
Solution
: SSRS is the tool that you use when generating a report that contains
details at the lowest grain, such as a list of orders or a customer list. Power View can
generate details but is much more suited for viewing higher-level summaries of data.
