We just installed service pack 10 for FRX. Since doing so, our transaction detail reports don't work when exported to Excel. We have a revenue report that is supposed to the customer name, invoice number, GL reference and GL description. When we export the report to Excel, the customer name and reference only print on the last page (the last company in the tree). If we run the report for one company at a time, we can get the detail, but if we run for more that one company at a time, only the last company shows the detail.
I have tried building a new column layout and new catalog, thinking the old ones may have been corrupted, but it didn't help. I haven't rebuilt the row format since it is so complex, but I tried adding transaction detail to some other reports that used different row formats, and the result was the same.
Has anyone else come across this? Is this one of those "undocumented features" in SP 10?