Discovere Report [message #365314] |
Thu, 11 December 2008 07:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jayashree Krish
Messages: 1 Registered: December 2008
|
Junior Member |
|
|
Hi,
I am working on the HRMS Discoverer Report.I am generating the hierarchy level report from parent org to the child org using the 'CONNECT BY PRIOR' an 'START WITH' clause.Now the problem is I am getting the topmost organization followed by the lower level org .I need to make this work in drill down option in Discoverer,so that once you give parent org on level 2 it should pull all the child org under that level till the last level. Could you please let me know how to do this in Discoverer..
Thanks,
Jayashree
|
|
|
|