Microsoft
70-466 · Question #6
70-466 Question #6: Real Exam Question with Answer & Explanation
The correct answer is D: Add a Measure group item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Category Groups.. To display an inline monthly trend graphic in an SSRS table, the chart item must assign MonthNumber to Category Groups to define the x-axis and RegCount to Values.
Question
You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year, as shown in the following diagram. You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column. What should you do?
Options
- AAdd an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property.
- BAdd a text box to a new column on the right of the Reg Count column. Then use a Go to report action to link to a separate report showing the monthly trend.
- CAdd a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Series Groups.
- DAdd a Measure group item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Category Groups.
- EAdd an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then select the MonthNumber field for Value.
Explanation
To display an inline monthly trend graphic in an SSRS table, the chart item must assign MonthNumber to Category Groups to define the x-axis and RegCount to Values.
Common mistakes.
- A. An Indicator item renders a single directional state symbol such as an arrow, not a multi-point trend line; there is no valid 'Start' property for MonthNumber in a directional indicator.
- B. A text box with a Go to report action navigates the user to a separate report rather than embedding a graphical trend visualization inline within the table row.
- C. Assigning MonthNumber to Series Groups creates one distinct data series per month value rather than placing months as sequential categories along the x-axis, which does not produce a monthly trend line.
- E. An Indicator item shows a single state icon and cannot render a trend across multiple data points; assigning MonthNumber to Value produces a numeric state reference, not a chart.
Concept tested. SSRS sparkline category groups vs series groups for trend display
Community Discussion
No community discussion yet for this question.