Microsoft
70-466 · Question #64
70-466 Question #64: Real Exam Question with Answer & Explanation
The correct answer is A: Adjacent Below. To place a second row grouping alongside but below an existing row grouping in an SSRS matrix, use the Adjacent Below option so both groups remain at the same hierarchy level.
Build reports
Question
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 in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year. 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?
Options
- AAdjacent Below
- BParent Group
- CAdjacent Above
- DChild Group
Explanation
To place a second row grouping alongside but below an existing row grouping in an SSRS matrix, use the Adjacent Below option so both groups remain at the same hierarchy level.
Common mistakes.
- B. Parent Group would promote the new Country group above the existing Category group in the hierarchy, making Category a child of Country, which inverts the intended structure.
- C. Adjacent Above would place the Country group rows above the Category rows, reversing the required display order shown in the diagram.
- D. Child Group would nest Country as a sub-group inside each Category row, creating a drill-down hierarchy rather than the parallel row layout required.
Concept tested. SSRS Report Builder matrix adjacent row group layout
Topics
#SSRS matrix#row grouping#adjacent group#Report Builder layout
Community Discussion
No community discussion yet for this question.