I am working on the SSRS BOMListingRpt report. Looks like there’s a limitation where you cannot join a parent to a child table multiple times with RDD
However, is it possible to create a nested query or do the join inside of the SSRS dataset query builder? If you look at the below, PartMtl is joined to PartRev at the top level. There’s the indented level for the subcomponent that I need to join back to PartRev to pull in Revision and Description at the detail/sub component level.
The highlighted orange is the idented part ID. I would like to join this back to PartRev to get the Revision ID and RevShortDesc.