No, does it need to be? I am tasked with taking a report and putting every single field on it to be exported to excel. It is to look exactly as is appears on the report so I am not sure switching it would be the best option unless there is no other option. I am all over the place on how to tackle the totals portion and thought it would be best to do it in the summary as opposed to trapping the data.
You're quite right that it's best done in the summary. You might find this trick helpful.
In the Table window, define a calculated field called "Record" with the formula Recno(). This will just list each record in the order it appears in the original report.
In the Summary, make the Recno() a key field (you can hide it) to force the ordering to follow the original.
You can handle more complicated requirements using other "invisible data" fields like Page(), Line() and Rowno(). There's a link to an old webinar on this here: https://www.livemeeting.com/cc/datawatch/view?id=QPC3BW-1[/url]
If you are still stuck, feel free to email me the report and model and I'll take a look.