Calculating Counts and Sums

[technoranger]

I need to develop a report on a database based on several fields. Program field has six options (A – F), Grade field has 12 options (1 – 12), Hours is a number field, and there is basic demographic data – name, etc. Individual records are based on Name.

What I need to end up with is a table with Program in the first column and Grades 1 – 12 as headings for rows 2 – 13. In each “cell” I need to determine the Count of students (based on Name) and Sum of Hours for each matching category, e.g. Where Program = A and Grade = 1: Count of students and Sum of Hours, Where Program = A and Grade = 2: Count of students and Sum of Hours…..through Where Program = F and Grade = 12: Count of students and Sum of Hours.

It seems there must be an easier way than defining 144 different “finds”. I’m trying to write it as a Case calculation, but that doesn’t seem right.

[Søren Dyhr]

It seems like what's called a crosstab report. It doesn't exist in filemaker natively you need to build it. First if you need to know how to make summary reports in filemaker watch this video:

Because - otherwise won't you be properly clad to get the gist of this:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

--sd