What should you do?

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year Month Number, and InvCount.

The report includes a table that displays the inventory count per year, as shown in the following table.

You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column.

What should you do?
A . Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.
B . Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups.
C . Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.
D . Add a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.
E . Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value.

View Answer

Answer: C