It would be extremely useful to have a Crosstab export the entire hierarchy as groups in Excel. SQL Reporting Services does this when exporting a report created there. I realize that this would mean generating the entire dataset prior to the export in order to expand all the data, but as I said, SSRS does this without a noticeable performance delay.