PrepAway - Latest Free Exam Questions & Answers

You need to modify the table to include a graphicalitem displaying the monthly registration trend to the right

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, asshown in
the following diagram.
You need to modify the table to include a graphicalitem displaying the monthly registration trend to the right of
the Reg Count column.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add a Sparkline item to a new column on the rightof the Reg Count column. Then select the RegCount field
for Values and the MonthNumber field for Category Groups.

B.
Add 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.

C.
Add 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.

D.
Add 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.

E.
Add a Sparkline item to a new column on the rightof the Reg Count column. Then select the RegCount field
for Values and the MonthNumber field for Series Groups.


Leave a Reply