Hi guys!
I need your help with an apex report (with editable items).
Story:
I have a table where I want to edit the values via an apex report (via textfields).
SELECT b_id, -- pk
b_c_id, -- category
b_u_id, -- user
b_mmyyyy, --month and year
b_1, -- monthly day with value to edit in report
b_2,
b_3,
...
b_29,
b_30,
b_31
FROM booking
The columns b_1 to b_31 are editable values (Text Fields) and I want to be able to update them over an unique value as a hidden item in my report.
The update process will look similar to that:
DECLARE
BEGIN
FOR i IN 1 .. HTMLDB_APPLICATION.g_f01.COUNT
LOOP
update booking
set b_1 = HTMLDB_APPLICATION.g_f01 (i),
b_2 = HTMLDB_APPLICATION.g_f02 (i),
b_3 = HTMLDB_APPLICATION.g_f03 (i),
b_4 = HTMLDB_APPLICATION.g_f04 (i),
b_5 = HTMLDB_APPLICATION.g_f05 (i),
b_6 = HTMLDB_APPLICATION.g_f06 (i),
b_7 = HTMLDB_APPLICATION.g_f07 (i),
b_8 = HTMLDB_APPLICATION.g_f08 (i),
b_9 = HTMLDB_APPLICATION.g_f09 (i),
...
b_29 = HTMLDB_APPLICATION.g_f29 (i),
b_30 = HTMLDB_APPLICATION.g_f30 (i),
b_31 = HTMLDB_APPLICATION.g_f31 (i)
where b_id = HTMLDB_APPLICATION.g_f32 (i);
I'm not able to get this value HTMLDB_APPLICATION.g_f32 (i); to see as a hidden value on my screen. Is it possible at all?
For example: When I set the "Display as" value to "Hidden" then the items doesn't appear on the screen. (Home>Application Builder>Application 100>Page 1>Report Attributes>Column Attributes>Tabular Form Element>Display As)
Any suggestion?
Thanks ahead,
Tobias