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
Messages: 5
Registered: October 2008
Junior Member
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 ....
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.

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

Current Time: Thu Jun 22 13:32:57 CDT 2017

Total time taken to generate the page: 0.22181 seconds