Counting in an export.

[macguys]

I have a pair of databases. The first one is a list of people and the second is a list of transactions. I create a report layout generated from the transactions database which shows a list of people who had transactions during the selected period, and the number of transactions that each had. To generate the number of transactions, I have a summary field and break on the individuals last name. It works fine, but I also need to be able to export the same data. Everything works fine on the export, except that the summary field is only included in the first record and it shows the total for all the people in the report. I know that this must be simple but I've tried everything I could think of. Any suggestions welcome.

[transpower]

By "export" what do you mean? If you need to save the information, print the report as a PDF.

[macguys]

The report has to be exported in a tab-delimited format so that it can be imported into another application.

Thanks

Dave

[macguys]

Another export weirdness. In the FMP 6 version of the database, I had a report from the transactions database that summarized the numbers of various kinds of transactions by zip code. Under 6, I was able to export this list without trouble. Under 7, I get one line with all the totals for the types of transactions and the rest of the report has one zip code per line and nothing else.

[macguys]

It turned out to be the same problem I had in earlier versions of FMP. In order to make changes to the way a list layout works in preview, you have to create a new layout. For me, trying to make sense of the preview/browse layouts is still an issue.

Thanks for the PM's.

Dave