Which two actions need to be performed so when the report is run, the columns appear as they do in the query on the report by default?

A new column called TEMPLATE (In bold below) was added to an existing Interactive Report
query as shown below.
SELECT title, product, release, subproduct, keywords, id,
focus_area, template, type, link
FROM content-repository
Which two actions need to be performed so when the report is run, the columns appear as they do
in the query on the report by default?

A new column called TEMPLATE (In bold below) was added to an existing Interactive Report
query as shown below.
SELECT title, product, release, subproduct, keywords, id,
focus_area, template, type, link
FROM content-repository
Which two actions need to be performed so when the report is run, the columns appear as they do
in the query on the report by default?

A.
Select Columns and move the TEMPLATE column to be displayed and move it up between
FOCUS-AREA and TYPE.

B.
Add a control break on the TEMPLATE column.

C.
Save the Report as Default Settings.

D.
Change the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and
TYPE.

E.
Create a sort on the TEMPLATE column.

F.
Reset the Interactive Report.

Explanation:
A: The new column need to be added to the report.
D: Editing Interactive Report Column Attributes
You can use the Column Attributes section of the Report Attributes page to precisely
control the report layout.
Common Report Column Edits for Interactive Reports include: Alter column display sequence.
Incorrect answer:
B: 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.
C: Saving Default Report Settings Default report settings determine the way a report initially
displays to end users. End users can then modify any of the settings.
To save default report settings:
1. Click the Actions menu and select Save Report.
2. From Save, select As Default Report Settings.
3. Click Apply.
F: Resetting a Report

You can reset a report back to the default settings by selecting Reset from the Actions
menu. Resetting a report removes any customizations you have made.
Reference: Oracle Application Express, Application Builder Users Guide, Release 3.2



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Edvard

Edvard

A,C options

Anna

Anna

should be A, C.
because for interactive report the column attribute doesn’t have sequence.