Hi Everyone,

I need to develop a report that could print invoice details of Parent BP & all the child BP linked to that Parent. Problem I am facing is when a BP range is given ,report prints details of Parent BP & first child BP falling between the range.I want report to dispaly details of all child BP irrespective of the range given on form.Please help!!!
Currently I am using code below

parent_busi=""
child_bp=""
select tccom100.* from tccom100
where tccom100.bpid inrange :ofbp.f and :ofbp.t
order by tccom100.prbp
selectdo

if parent_busi<>tccom100.prbp and parent_busi<>"" then
parent_details()
child_details()
parent_busi=""
child_bp=""


endif
parent_busi=tccom100.prbp
child_bp=tccom100.bpid

endselect
parent_details()
child_details()
}