The Interactive Report is displayed in Exhibit 2 
Which combination of three actions would need to take place to create the interactive report?
A.
Create an Interactive Report region to show the list of EMPLOYEES and PRODUCTS based on
the Customer ID.
B.
Create an Interactive Report region that contains a query between the CUSTOMERS,
EMPLOYEES, PRODUCTS and SALES table.
C.
Create an SQL Report region that contains a query between the CUSTOMERS, PRODUCTS
and SALES tables only.
D.
Create a filter on Customer FIRST_NAME and LAST_NAME.
E.
Create a Control Break on Sales Representative.
F.
Concatenate FIRST_NAME and LAST NAME for both CUSTOMERS and EMPLOYEES in the
query.
Explanation:
B: The report needs to access data from all four tables.
E: You can create a break group of one or several columns by selecting Control Break
from the Actions menu. Creating a break group pulls the columns out of the
interactive report and displays them as a master record.
F: The concatenated names of the Sales Representative (from Employee table) and the
concatenated names of Customers are used.
Note: Interactive reports include components that enable users to alter the layout of report
data. Users can select columns, create filters, apply highlighting, sort columns, define
break groups, aggregate columns, create charts, and define computations. Once
customized, users can then save an interactive report as named report and download
the data to various file formats.