Newbie - How do I get this result?

[rcorbitt]

I sell small ads in several newspapers in the Southeast. I am trying to create a layout that will generate an "Excel" like format. Currently my database contains the name of each newspaper, each advertiser, the date of the advertisement, and the number of ad(s) for each advertiser that were printed in the newspaper.

I need the print out to look like this:

[Vaughan]

FMP cannot do arrays like this easily. It can be done, but it's usually a *lot* of work.

FMP does summary reports linearly:

6/1/04

ABC Company 1

BCD Company 0

CDE Inc. 2

6/8/04

ABC Company 0

BCD Company 2

CDE Inc. 2

It generally takes orders of magnitude less time to convince people to accept the "linear" format than it does to muck around creating the array format.