A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?
A . Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
B . Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
C . Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.
D . Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.
Answer: A