You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee.
Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee.
You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report.
What should you do?
A.
Use a subreport.
B.
Use a bookmark link.
C.
Use the drilldown functionality.
D.
Use a drillthrough report link.
Explanation:
Tip: "click a value … to open and render" = "drillthrough"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