You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Reporting Services (SSRS) report that meets the following requirements:
-Displays sales data for the last 12 months.
-Enables users to view the sales information summarized by month.
-Enables users to view individual sales orders for any given month.
You need to design the report to minimize the impact on bandwidth.
What should you do?
A.
Create a standard report that contains all sales orders. Implement report filtering based on the month.
B.
Create a standard report that contains all sales orders. Implement grouping for the monthly summaries.
C.
Create a standard report that contains the monthly summaries. Create a subreport for the sales orders for any given month.
D.
Create a standard report that contains the monthly summaries. Create a drillthrough report for the sales orders for any given month.
Explanation:
Tip: "minimize the impact on bandwidth" = "drillthrough"Drillthrough Action Defines a dataset to be returned as a drillthrough to a more detailed level.
Creating Drillthrough Actions
For the most part, Drillthrough Actions have the same properties as Actions. Drillthrough Actions do not have Target Type or Target Object properties. In their place, the Drillthrough Action has the following:
– Drillthrough Columns Defines the objects to be included in the drillthrough dataset.
– Default A flag showing whether this is the default Drillthrough Action.
– Maximum Rows The maximum number of rows to be included in the drillthrough dataset.
(McGraw-Hill – Delivering Business Intelligence with Microsoft SQL Server 2008 (2009))http://technet.microsoft.com/en-us/library/ff519554.aspx
Drillthrough Reports (Report Builder 3.0 and SSRS)
A drillthrough report is a report that a user opens by clicking a link within another report. Drillthrough reports commonly contain details about an item that is contained in an original summary report. The data in the drillthrough report is not retrieved until the user clicks the link in the main report that opens the drillthrough report. If the data for the main report and the drillthrough report must be retrieved at the same time, consider using a subreport