A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/ Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result: What must the report author do for the report to look like the following?
A report author created a crosstab as shown below:
The crosstab report, when run, shows the following data:
The author wants to split the revenue for each region by year.
Where should the year data item be added?
A report author has created this join relationship: The Order number by product query includes only orders that contain a specific product selected at run time. What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?
The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report. Which statement about Master detail relationships is true?
A companys marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report). How can the report author provide users with a clickable download link for the media file in the report performance list?