Find on Calculated field

[Gobae]

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

[danjacoby]

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.

[Unable]

"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.

[danjacoby]

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.

[Unable]

Thanks danjacoby.

[danjacoby]

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