Nested Work Orders

[Llazwas]

I'm working with a ProvideX database using Crystal X. I'm trying to write a work order report that shows nested work orders. I need to see if one work order is being made for another work order but it could be several layers deep. From what I've found you can't do nested subreports. Any ideas?


My tables and fields are:
WO_Header
{WO_Header.WONumber}
{WO_Header.ParentItemNumber}
{WO_Header.MakeForWONUmber}
WO_Detail
{WO_Detail.WONumber}
{WO_Detail.ComponentItemNumber}

Table links:
{WO_Header.WONumber}----->{WO_Detail.WONumber}

Subreport links:
{WO_HeaderWONumber}------->{WO_Header.MakeForWONmber}
{WO_Detail.ComponentItemNumber}------->{WorkOrder_Header.ParentItemNumber}

The main report currently shows:One sub-report, data in italics

50567 {WO_Header.WONumber} (grouped by)
Lamp {WO_Header.ParentItemNumber}
Cord {WO_Detail.ComponentItemNumber}
50568 {WO_Header.WONumber}
Cord {WO_Header.ParentItemNumber}
Wire {WO_Detail.ComponentItemNumber}
Plug {WO_Detail.ComponentItemNumber}
Shade {WO_Detail.ComponentItemNumber}
Base {WO_Detail.ComponentItemNumber}
Bulb {WO_Detail.ComponentItemNumber}


What I need it to show is:Two+ nested sub-reports, data in italics


50567 {WO_Header.WONumber} (grouped by)
Lamp {WO_Header.ParentItemNumber}
Cord {WO_Detail.ComponentItemNumber}
50568 {WO_Header.WONumber}
Cord {WO_Header.ParentItemNumber}
Wire {WO_Detail.ComponentItemNumber}
Plug {WO_Detail.ComponentItemNumber}
50569 {WO_Header.WONumber}
Wire {WO_Header.ParentItemNumber
Shade {WO_Detail.ComponentItemNumber}
Base {WO_Detail.ComponentItemNumber}
Bulb {WO_Detail.ComponentItemNumber}

 

[lbass]

I'm not totally clear on your data, but you could add the table a second time in the main report instead of one of the subreports.

-LB