PrepAway - Latest Free Exam Questions & Answers

Which Row Group option should you select when you add the group?

You are creating a new report in SQL Server Report Builder.
You add a SQL Azure data source.
Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following diagram.

The category rows (the first three rows as shown inthe diagram) must present total sales amount by category.
The country rows (the next six rows as shown in thediagram) must present total sales amount by country.
The total row must present the total sales for eachyear.
You add a matrix to the report.
You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?

PrepAway - Latest Free Exam Questions & Answers

A.
Parent Group

B.
Child Group

C.
Adjacent Below

D.
Adjacent Above


Leave a Reply