Hello,
I have one classic report based on a table "t" where data looks like :
now I would like to show tooltip on every individual cell (from T1 to T8 ) based on the table "P" where we have information about who has modified this cell at what time.
so if user mouse over to the value of column T1 (value =275) then tooltip should show as (title="Modified by '|| p.modby|| ' at '|| p.moddate) same for the other columns as well.
please help me out like how to make a query for the classic report.
Oracle apex version: 4.2
db version- 12c
with t as
(select 'xyz' item_id, 386 item_code, 275 t1, 350 t2, 300 t3, 350 t4, 363 t5, 364 t6, 671 t7, 0 t8 from dual ) select * from t;
with p as
( select 'xyz' item_id, 386 item_Code, 't1' mon,275 qty, 'user1' modby, sysdate-1 moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't2' mon,350 qty, 'user2' modby, sysdate-10 moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't3' mon,300 qty, 'user1' modby, sysdate-2 moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't4' mon,350 qty, 'user3' modby, sysdate-3 moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't5' mon,363 qty, 'user11' modby, sysdate-2 moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't6' mon,364 qty, 'user10' modby, sysdate moddate from dual
union all
select 'xyz' item_id, 386 item_Code, 't7' mon,671 qty, 'user5' modby, sysdate-7 moddate from dual
) select * from p;