Is this assembly breakdown report possible ?

[boardburner]

Using CR9
I am having no luck trying this in Hierarchical Grouping Options, the sub #'s will not break out with detail.
Here is a brief explanation on what I need. (need to pull in 4 sub PN#'s) I guess you could call this an assembly breakout.

Chosen Main assy PN# from parameter: #9400
First sub assy PN: #2003 (has 3 sub PN#'s)
(1)Component PN: #0812 + detail + Qty (has sub Mat'l #)
(2)Material PN: #0662 + detail + Qty
Component PN: #0912 + detail + Qty (has sub Mat'l #)
Material PN: #0482 + detail + Qty
Component PN: #0602 + detail + Qty (has sub Mat'l #)
Material PN: #0622 + detail + Qty
Second sub assy PN: #2002 (has 2 sub PN#'s)
Component PN: #0312 + detail + Qty (has sub Mat'l #)
Material PN: #0652 + detail + Qty
Component PN: #0712 + detail + Qty (has sub Mat'l #)
Material PN: #0412 + detail + Qty
Third sub PN: #1002 (has only 1 sub PN#)
Material PN: #0652 + detail + Qty

Etc. Etc. Etc

Thankfully all these PN#'s and associated subs are in the same 2 tables. Each Parent PN# field {JMTHM.JSPART}has an associated part Mat'l. {JMTHM.JSMPRT} field. The master part table with the assy pn's is linked outer left = to the JMTHM table by PN. I can get the first level to work great...just not any further! Some part #'s are alone, meaning they have no sub part #'s but others have up to 3. Not sure if this is even possible with CR9.

Thanks again
G