Exporting Single records of Grouped Data

[Joel Saltzman]

I have a report run on all the line items of products that have sold. It gourps the data together in the preview mode to show the total number of each unique item sold. When I export the info it exports like I were browsing the records. I mean each line item shows how many times it was sold and not the total.

Example:

Part: 1234 Name:Widget QTYSOLD:1

Part: 1234 Name:Widget QTYSOLD:1

Part: 1234 Name:Widget QTYSOLD:1

Part: 5678 Name:MYWidget QTYSOLD:1

Part: 5678 Name:MYWidget QTYSOLD:1

Instead of:

Part: 1234 Name:Widget QTYSOLD:3

Part: 5678 Name:MYWidget QTYSOLD:2

Any Ideas?

[comment]

First, you need a summary field, defined as Total of QTYSOLD.

Then specify your export to group by Part.

---

Note that you have to sort by Part before exporting.

Edited February 26, 2007 by Guest

[Joel Saltzman]

AH HA, thanks!