APEX

I've really tried to find an answer to this, but can't seem to get HTML text showing up in my Tabular Report instead of the (updatable) actual field value.

My query works fine w/o the apex_item.text call; it shows the field value I'm trying to allow the user to update. I've tried changing the p_idx (first) parameter to various (larger) numbers, thinking I was stomping on an existing array being used by another field, but no help. My query contains a field that uses apex_item.checkbox, so maybe that's throwing the apex_item.text off?

Here's the column definition:

APEX_ITEM.TEXT(10, r.advance_id, 12, 10) AS advance_id,

Parameters:

10 - use array f10
r.advance_id - save the value of the table column advance_id (or whatever the user replaces it with) into the f10 array
12 - display column size
10 - maximum length

What I'm seeing in the field value:

<input type="text" name="f30" size="20" maxlength="2000" value="44222" />

where 44222 is the value of the column for that row.

Here's the full query, if that will help:

SELECT r.harris_first_name || ' ' || r.harris_last_name AS names,
apex_item.checkbox(5, r.order_id || '-' || r.xsequence,
CASE WHEN r.approved_ind IS NOT NULL
THEN ' disabled '
ELSE ''
END, 'Y')
as approved_ind,
r.host_advance_id as harris_id,

APEX_ITEM.TEXT(10, r.advance_id, 12, 10) AS advance_id,
CASE
WHEN NVL(r.confidence_score, 0) > 0
THEN 'NVL(TO_CHAR(r.confidence_score), '0')
ELSE ''
END AS match_score,
CASE
WHEN r.identification_source IS NULL THEN
'Not matched'
ELSE
INITCAP(r.identification_source)
END AS identified_by,
r.order_id,
r.xsequence,
DECODE(r.xsequence, 0, 'Host', 'Guest') AS host_guest,
r.order_id as harris_order_id,
r.loaded_date
FROM "#OWNER#"."HARRIS_EVENT_REGISTRANTS" r
WHERE r.advance_event_id = :APP_EVENT_ID
AND instr(':' || :P3_SEARCH_STATUS || ':',NVL(approved_ind, 'N'))> 0

Thanks,

Stew

p.s. Am I reading the 3.0 User's Guide badly, or are the parameter definitions for apex_item.text wrong?