count number of occurrences in a found set

[dervaish]

hello

got another issue that needs to be solved. i have a script that does a find n perform find routine and returns a number of records based on a set criteria. i know i can use get(foundcount) function to get a number of all records in the found set. but how can i break down that foundset even further and count how many records have one specific value.

lets say my search returns 5 records. two have "1" as value, 2 have "2" as value and 1 has "5" as value. this is the count i want.

Total records found : 5

FURTHER BREAKDOWN

====================

2 records with value "1" found

2 records with value "2" found

1 record(s) with value "5" found.

===================================

i know its a tricky thing but i'm sure someone with enough FM experience must know how to achieve this.

thanx in advance.

[comment]

Mikhail Edoshin's "Fast Summaries" should come in handy for this:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

[LaRetta]

Well, I again suggest an old fashioned columnar report with grouped data as explained here .

I sure am feeling old fashioned today. What, was FM reporting discontinued and I wasn't notified? :shocked:

[comment]

You are right. I assumed dervaish is familiar with basic reporting with sub-summaries, and that the request is for an alternative that can be viewed in Browse mode.

[LaRetta]

And it may very well be for browse mode ... It is a good reminder for me ( I can tend to become too narrow-focused ) that, in this type of situation, there are two questions which I should ask:

1) How do you need the results displayed?

2) Does the field in question contain one value per record or can it contain multiple values, ie, checkbox data as in a multiline?

Item 2 caught me off guard just today elsewhere! Thanks for making me not feel so old fashioned. :wink2: