Jump to content

  •  

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,562 posts
  • Time Online: 344d 14h 48m 5s

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