Databases Reference
In-Depth Information
CSS and HTML formatting directives entered in the Column Formatting region are applied to the report column
when the page is rendered:
8.
In the
Column Formatting
section, enter
font-weight:bold
for the
CSS Style
field
(Figure
6-34
). Click
Apply Changes
.
Figure 6-34.
Choosing column formatting options
Edit the
TICKET_ID
column by clicking its edit icon.
9.
10.
In the
Column Definition
region, set
Include in Export
to
No
, and click
Apply Changes
.
11.
Run the page to view your changes.
Note that when you sort an APEX report column by date, the report sorts based on the value of the actual date,
not the displayed value. This is a built-in feature of APEX. Also, when you export to Excel, the
TICKET_ID
column isn't
part of the resulting CSV file, which is the result of your setting the Include in Export option to No.
Next, remove
STATUS_ID
and replace it with the corresponding value, pulled into the report by a slight adjustment
to your query:
1.
Edit
Page 200
in your application.
2.
Edit the report attributes again by right-clicking the
Tickets
region and selecting
Edit
Report Attributes
.
3.
Click the
Query Definition
subtab near the top of the page.
4.
Click the
Add/Remove Columns
button.
5.
See Figure
6-35
. Ensure that
Table/View Owner
is set to your schema name and that
Show Related Tables Only
is set to
Ye s
.
