I have a baq that uses recursion to indent or explode a bom to the nth level. It puts the parent part in a column and material parts in a column. I need to see the parent part in the column with the materials or stacked. Any idea how this can be done?
I’m not sure I fully understand. Maybe a picture example?
Can’t you just use a union query to display those values?
Jason Woods
http://LinkedIn.com/in/jasoncwoods
1 Like
I’m new to CTE’s so I’m not exactly sure how to incorporate a union. I always have trouble getting the same number of fields to match.
I think I have a union in place, however it only stacks some of the data and not the part numbers.
I’ve tried several different union methods and the query will always timeout. I have a timeout time set to 600. Returns zero lines. Very disappointing. Any help is appreciated!
Can you post the BAQ here? I’ve made a couple recursive CTE queries and try to use a field called RelativeDepth for indentation (use a VB function to repeat a string) in an SSRS report. The “parent” record has RelativeDepth = 1 and the “child” records have RelativeDepth = ParentRecord.RelativeDepth + 1
1 Like