Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Find on Calculated field


Gobae

This topic is 7859 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7859 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.