Home » Developer & Programmer » Reports & Discoverer » Prob to implement "START WITH" clause in discoverer report condition (Discoverer 10g)
Prob to implement "START WITH" clause in discoverer report condition [message #382358] Thu, 22 January 2009 00:45
ide007
Messages: 5
Registered: October 2008
Junior Member
Hi,
I am working on the HRMS Discoverer Report.I am generating the position hierarchy report from parent position to the child position using the 'CONNECT BY PRIOR' an 'start with' clause.Now the problem is in the folder I have used the main query but "start with" can not be used in Folder query.

I am having two paramwters; one for Top position and another for choosing the number of levels below the top position.

The query is like below:
Select level, ...
from ....
where
level <= nvl(p_no_levels,level) --parameter
start with pap_p.name = 'p_top_pos' --parameter
connect by prior ppse.SUBORDINATE_POSITION_ID = ppse.parent_position_id


Could you please let me know how can I add this "start with clause" in my discoverer report conditions.

Thanks
Previous Topic: Printed Purchase Order Report
Next Topic: Removing Blank/Empty Lines from Oracle Report
Goto Forum:
  


Current Time: Sun Dec 04 20:30:19 CST 2016

Total time taken to generate the page: 0.09207 seconds