The Interactive Report is displayed in Exhibit 2 Which combination of three actions would need to take place to create the interactive report?

Question

Exhibit

Options

• ACreate an Interactive Report region to show the list of EMPLOYEES and PRODUCTS based on the
• BCreate an Interactive Report region that contains a query between the CUSTOMERS, EMPLOYEES,
• CCreate an SQL Report region that contains a query between the CUSTOMERS, PRODUCTS and
• DCreate a filter on Customer FIRST_NAME and LAST_NAME.
• ECreate a Control Break on Sales Representative.
• FConcatenate FIRST_NAME and LAST NAME for both CUSTOMERS and EMPLOYEES in the query.

• A
  11% (6)
• B
  83% (45)
• C
  4% (2)
• D
  2% (1)

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.

No community discussion yet for this question.