nerdexam
Microsoft

70-466 · Question #6

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

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.

Build reports

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.

How the community answered

(22 responses)
  • B
    9% (2)
  • C
    14% (3)
  • D
    73% (16)
  • E
    5% (1)

Why each option

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.

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.

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.

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.

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.

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.

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.

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.Correct

In SSRS, a sparkline-type report item renders an inline trend by mapping the measure field (RegCount) to Values and the time/sequence field (MonthNumber) to Category Groups, which places each month as a discrete point along the x-axis. Option D correctly uses Category Groups for MonthNumber, producing one plotted point per month that visualizes the registration trend across the year.

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.

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

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/sparklines-and-data-bars-report-builder-and-ssrs

Topics

#sparkline#data bar#trend visualization#table report items

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice