You are developing a SQL Server Reporting Services (SSRS) report.
The report includes a dataset with fields named Year, MonthNumber, and InvCount.
The report includes a table that displays the inventory count per year, as shown in the following diagram.
You need to modify the table to include a graphicalitem displaying the inventory count trend to the right of the
Inv Count column.
What should you do?
A.
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.
B.
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.
C.
Add a Sparkline item to a new column on the rightof the Inv Count column. Then select the InvCount field
for Values and the MonthNumber field for Series Groups.
D.
Add a Sparkline item to a new column on the rightof the Inv Count column. Then select the InvCount field
for Values and the MonthNumber field for Category Groups.
E.
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.