Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Summary Report

sort problem

  • Please log in to reply
2 replies to this topic

#1 adyf  novice

adyf
  • Members
  • 222 posts
  • LocationUnited Kingdom
  • FM Application:11 Advance
  • Platform:Windows 8
  • Skill Level:Novice
  • Time Online: 5d 2h 19m 30s

Posted 02 March 2012 - 10:38 AM

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?
  • 0

#2 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 16h 53m 57s

Posted 02 March 2012 - 02:41 PM

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'.
  • 0

#3 adyf  novice

adyf
  • Members
  • 222 posts
  • LocationUnited Kingdom
  • FM Application:11 Advance
  • Platform:Windows 8
  • Skill Level:Novice
  • Time Online: 5d 2h 19m 30s

Posted 04 March 2012 - 11:11 AM

Thanks comment, worked a treat as always.
  • 0




FMForum Advertisers