AnsweredAssumed Answered

Exporting Sub Summary reports to excel

Question asked by henryoswald on Dec 7, 2009
Latest reply on Dec 7, 2009 by henryoswald

Title

Exporting Sub Summary reports to excel

Post

I've got a report which takes a few thousand records and groups it into about 100 or so lines. there are 3 fields,

Name
Date
Total
- this is a total summary field which looks at a different field

There is only one part to the report, which is a sub summary when sorted by the field 'Date' I do a sort on Name first then Date, this gives me a long list where all three fields are permanently populated. i.e.

Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total
Name Date Total

However when I export to excel I group the total by Date this is 95% right but the name field is only populated at the top i.e.

Name Date Total
_____Date Total
_____Date Total
_____Date Total
Name Date Total
_____Date Total
_____Date Total
_____Date Total
Name Date Total
_____Date Total

Is there a way I can export to excel (csv/tab) or any work around so I get the same list of values as shown in my report?

Feel like I’m taking this forum over, but thanks for any advice, I've been trying to work this out for a couple of days.
















Outcomes