We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content
Sign in to follow this  
adyf

Summary Report

Recommended Posts

adyf    0

I have a field called sCount which is a summary of the 'name' field. I would like to sort by sCount but I don't believe that I can because it is a summary field and it is greyed out in the sort dialogue box. I would like to sort my report by sCount descending because I would like to show the 'Name' with the most records first and so on in order to identify training priorities. Is there a way to do this?

PS I did find a work round. I created a loop script that would enter sCount for every record of my found set into a number field. I then sorted using this number field and used as sub-summary on my report. Is there a cleaner way though?

Share this post


Link to post
Share on other sites
comment    1,357

I would like to show the 'Name' with the most records first

Sort by Name, descending and select the option 'Reorder based on summary field: sCount'.

Share this post


Link to post
Share on other sites

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

Sign in to follow this  

×

Important Information

By using this site, you agree to our Guidelines.