SSRS Report - Group By Tablix with a second Tablix outer joined and following first one - how to do such ? pictures included

Finance and Operations/AX Developer Forum
1

Hello,

i need to create a report which would print bom lines of a works order and be grouped by BOMId - i achieved this, but now i need to add additional tablix following each bom lines section with routes information, picture example is bellow, how is this achieved ?

if there will be 2 boms, it must print

BOMId A

BOMLine 1

BOMLine 2

RouteId A

RouteLine 1

RouteLine2

BOMId B

BOMLine 1

RouteId B

RouteLine 1

routes.jpg