You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. You create a report named ProductSales by using Microsoft Visual Studio .NET 2008. The report must display the following details:

The product category as rows and the corresponding year of sales as columns. The total amount of year-wise sales for each product category. The number of product categories and the number of sales years for the report can vary. You need to display the sales details in the report effectively. Which report item should you add to the report?

Question

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. You create a report named ProductSales by using Microsoft Visual Studio .NET 2008. The report must display the following details:

The product category as rows and the corresponding year of sales as columns. The total amount of year-wise sales for each product category. The number of product categories and the number of sales years for the report can vary. You need to display the sales details in the report effectively. Which report item should you add to the report?

Accepted Answer

C. Matrix

Answer

A. Rectangle

Answer

B. Textbox

Answer

D. Subreport

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. You create a report named ProductSales by using Microsoft…

Question

Options

How the community answered

Community Discussion