RE: Explosion of Production BOM
Worth considering the report you originally identified only shows the assigned Production BOM on an item. It only filters on “Closed”. I think you want a generic print out of all production BOMs regardless as to whether they are assigned to a finished goods item.
If that’s the case then a standard report does not exist. The page I mentioned previously is again for a production BOM assigned to an item. To get a report regardless of that you could try publishing a web service for page 99000788. That’s the line level of production BOMs. It doesn’t include the status though. You can publish a web service for the “header” type table and then fuse them together in a power query for example.
I think it would be best to have a report created based on your needs. Whether that’s a BC report, Power BI or other.