This content has been marked as final. Show 2 replies
Apex - 4.0 and Oracle -11g
I m having a SQL Query report.
SELECT htmldb_item.hidden(1,id) id,
htmldb_item.select_list_from_query_xl(2,name,'SELECT name ,
WHERE name like ''E%''') name,
htmldb_item.select_list_from_query_xl(3,deptname,'SELECT deptname from dept where deptid = ???') deptname
My problem, in the report when the Select list for 'name' has been choosen , then it should retrieve the deptname based on the 'name'.
Is it possible ?