Newbies Gobae Posted March 28, 2003 Newbies Share Posted March 28, 2003 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 More sharing options...
danjacoby Posted March 28, 2003 Share Posted March 28, 2003 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 More sharing options...
Unable Posted March 29, 2003 Share Posted March 29, 2003 "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 More sharing options...
danjacoby Posted March 29, 2003 Share Posted March 29, 2003 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. Link to comment Share on other sites More sharing options...
Unable Posted March 29, 2003 Share Posted March 29, 2003 Thanks danjacoby. Link to comment Share on other sites More sharing options...
danjacoby Posted March 29, 2003 Share Posted March 29, 2003 I'm also available for weddings, bar mitzvahs ... Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now