Export sub-summary's to excel?

[meglome]

I'm doing a favour for a friend and I'm really pulling my hair out. I need to export a report to excel which contains sub-summary's sorted by date. It's a list of dates with totals which I can view on screen, print or export to pdf. However all I can get in excel is a list of dates with a grand total next to the first date. I must be missing something. Any help appreciated.

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/212491/post/346682/#346682

[meglome]

Thanks for your reply.

If I understand this correctly if I want to do the following (with the totals being sub-summary's by date) and get it into excel:

Date Amount

Jan 20.00

Feb 10.00

Mar 15.00

I can't do this, I need to use xml?

Cause as I mention above right now the best I can get is:

Date Amount

Jan 45.00

Feb

Mar

[comment]

Does this work for you?

SummaryExport.fp7.zip

[meglome]

Thank you so much for your help. Not sure I would have ever figured that our myself.