How do I export an entire BOM tree?

Hi, We're running SAP B1 2007. I'm trying to export and entire BOM list for a specific product. I can easily bring up the BOM and export it to Excel but it just exports the BOM for that item and not its children and grand children. Is there any kind of report that will do this for me?

Thanks!