单项选择题
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.
相关考题
-
单项选择题
YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.YoucreateaSQLServer2008ReportingServices(SSRS)solution.YoucreatereportsbyusingMicrosoftVisualStudio.NET2008.Thedevelopmentteamofyourcompanymustcreate50SSRSreports.Youneedtoensurethatthecompanylogoandthecompanynameareincludedinthepageheaderofallthereports.Whatshouldyoudo?()
A. Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
B. Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
C. Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
D. Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports. -
单项选择题
YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.Youplantodesignthereportstrategyforanewreportprojectthatwillbeusedbyafinancialapplication.TheapplicationusesfivecalculationsthatareimplementedinMicrosoft.NETFramework3.5assemblies.TheassembliesarewrittenintheC#languageandusethestaticmethods.Youneedtoensurethatthecalculationscanbeusedbytheexpressionsinallreports.Youalsoneedtoensureconsistencywithinthereportsbyusingtheleastamountofdevelopmenteffort.Whatshouldyoudo?()
A. Add a reference to the assemblies in the Report Properties References tab.
B. Write the calculation logic used by the calculations by using T-SQL functions.
C. Write the code of the calculation logic into the Report Properties Custom Code tab.
D. Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services (SSRS). -
单项选择题
YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.ASQLServer2008AnalysisServices(SSAS)solutioncontainsacubethathasthefollowingobjects:·DimensionsnamedDimCustomer,DimProduct,andDimGeography·MeasuresnamedInternetSalesandTotalSalesUsersrunreportsagainstalldimensionsandmeasuresbyauthenticatingwiththeirWindowsaccounts.YouneedtoprovideabasicviewofdatatotheuserstodisplayonlyDimGeography,DimProduct,and TotalSalesbyusingtheleastamountofstoragespace.Whatshouldyoudo?()
A. Create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales.
B. Create a new cube. Add DimGeography, DimProduct, and TotalSales.
C. Create a new role. Grant access only to DimGeography, DimProduct, and TotalSales.
D. Create a new data source view. Add the tables used for DimGeography, DimProduct, and TotalSales.
