Pulling data and data associated with record

[ss7415]

i have never come across this , i would appriciate some assistance.

I am using crystal xi and oracel 9i

i have two main fields wo_nbr and a lot_nbr (i am only looking at lot_nbr with a 'W' as the first character).
wo_nbr will be a parameter.

when i return my records with that wo_nbr, i want it to look at the lot_nbr and grab the data associated to those lot_nbr and those accosicated with those , until it captures all the data.

so the data will start at a level and i want to get all the data associated below that level.

if i need to explain more plese let me know.

 

[ss7415]

i believe it will be some type of heiarchy

 

[synapsevampire]

In XI try Report->Hierarchical grouping and select Sort Data Hierarchical and select the fields involved.

-k