Is there a way to do a find on a summary calculated field after the report is run? Or a sort?

If not can the results be placed in a perminent field in the same database?

Currently we are running the report and then exporting the information to another fp5 to do the find and sort.

Dan

You can't do a find on a field that is in a summary part, because that part only shows up in Preview mode.

You can't sort on a Summary field, since it's not directly connected to a record, and you're sorting records.

You can, however, (assuming you're sorting based on a Summary that is the total of some other field) create a self-relationship based on the key field for the Summary part. Then create a calc field that equals the Sum of the field whose sum you're sorting on. Then do the sort based on that calc field.

It's one idea.

"You can't do a find on a field that is in a summary part, because that part only shows up in Preview mode"

What happens if you also place the summary field on a different layout not in a summary part? Can the data of the summary be accessed that way? Just curious.

You can put a summary field in the body, but you won't be able to enter data into it while in Find mode. Try it, and you'll see.

Thanks danjacoby.

I'm also available for weddings, bar mitzvahs ...