Tree View component in Oracle Reports

[korhanyunak]

Hi all;

Could anyone tell me how to create tree view in Oracle Reports allowing users to navigate within the report items itself ?

For Example:

Column1
+A
+B
-C
+D
-E
-F

 

[HimanB]

Hi,
Use follwoing query in your report builder and set horizontal elsticity of you feild as Varibale or Expand
to achive this:

select v.org_chart
from
(select lpad(' ',2*(level-1))|| ename org_chart,
from emp e
connect by prior empno = mgr
start with mgr is null ) v,
dept d
where d.deptno = v.deptno;

Regards
Himanshu