In creating an Order Action Report within OE, there appear to be some limitations (?) (Maybe mine!) which I?m hoping you can help me overcome.

1. Getting report totals. Is there a way to get a total value at the end of the report? I get a summary of purchases for a series of items, but no final total which would be useful. I need to know my sales totals for a particular category or vendor. When I created this report, I was forced to add up the sales values manually. It seems like it should be so easy to get the report to total.
2. Exporting the report - I tried exporting the report to an excel file so that I would be able to total columns that way, but it doesn?t export neatly ? the columns don?t separate. (When there was a report preview on my screen, there was an export option icon at the top.
I tried exporting to an excel file, to a lotus file, and even to a csv file which I then brought into excel ? but got nothing I could use. The columns from the report would not separate into columns in Excel. Is there a way to resolve this? Thanks.

(I am trying to create an Order Action report in Gridview - but that's a whole new set of challenges and fodder for different posts!)