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.
