It depends on which version of XI.
There is a really good spreadsheet macro for XI R3 that you can get from busobj.forumtopics.com.
But, the "normal" way to do this is with the query builder in XI. It sucks at formatting, but it gives you the data.
Steve Krandel
Intuit