OraFAQ Forum: Reports & Discoverer » Prob to implement "START WITH" clause in discoverer report condition

Home » Developer & Programmer » Reports & Discoverer » Prob to implement "START WITH" clause in discoverer report condition (Discoverer 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 05:45:41 CST 2024