Summary in a found set?

[peoplayer]

This is probably a pretty easy question for al pros around here. Here it is:

I have an invoicing file, containing all the sales of a company. This file contains (among other fields) article#, serial# (unique), sales date and client name. I would like to make a listing showing how many items of the same article# have been sold. That is, something like this:

Article# Items sold

512-121 2

545-236 65

343-656 12

Total items sold: 79

The thing is, that I would like to do this when doing a find. I would like to be able to search in different date ranges and the respective results should show then. Is this possible, and how should I do it?

Thanks in advance,

Per-Otto Lekare

Mexico City

[LiveOak]

You can do this with a layout containing:

Header

Subsummary when Sorted by Item#

Footer

Create a summary field "TotalItems". The definition of this field will depend upon how quantities are stored in your file. If each record has an item quantity, the field will be a summary field defined as "Total of ItemQuantity". If you have one item per records, the field will be defined as "Count of Item#". Place the Item# field and the TotalItems fields in the subsummary part.

Perform the finds you need to create the appropriate found set, sort by Item#, and enter preview mode.

-bd