Combine one field from found set into a summary

[haggie]

I have a report I run weekly. Right now, I export one field from the database, open it in Excel, copy the data from that one field from about 300-500 records, and paste the data into another application. I would love to be able to skip the export step to just do a search, copy the summary-style results for the appropriate field from my found set from one field, and paste into another application..

Is it possible to have all the data from a calc field be displayed in one field for the found set.

For example, if field X was a text field and field X for the found set has the following values: record1="cat", record2="dog", record3="bird". Can you create a summary-type field that would display?

cat

dog

bird

All the above values would be in one field so I could easily cut and paste the contents of that summary field.

Many thanks!

[-Queue-]

You could do this in a couple of ways. The easiest would probably be to create a script to

Freeze Window

Set Field [fulltextfield; ""]

Go to Record/Request/Page [First]

Loop

Set Field [fulltextfield; fulltextfield & fieldX &