I need to display some data like this:
54001 C C C C
52768 C NC C N/A
Reach (Y-82) NC due to 431-145-2 Purchased from Futuristics Components Inc (Supplier #191100) non-compliant
101-4030 C C C C
3190-278 C C C C
RoHS NC Purchased from Santron Inc (Supplier #XXXXX) non-compliant
101-0032 C C C C
Please notice the 2 red detail lines. Can I achieve this with crosstab ? If so, how? I think I'm stuck with crosstab because the last 4 columns are dynamic and I need crosstab's column group feature to display them.