I have a simple report that lists Faculty by their Credential (Doctorate, Masters, Degree, etc)
The goal is to have a list, by name, of all faculty that have a specific credential.

The list is Counted as well.

The problem is that many faculty have more than one credential of the same type (eg. two Degrees).

I want to see the description of the credential (so I know what it is for) and a count of faculty that have it. What I have lists all the faculty with that credential and it shows multiple credentials for those that have them but I can not get an accurate count of the number of faculty.
What I get is a count of the Credentials.

The tables involved are: (abbreviated for your sanity :-)

Faculty
-FacultyID
-FirstName
-LastName

-Name_Last_First (calculation)

FacultyEducation
-FacultyEd_ID
-FacultyID
-CredentialType
-CredentialDescription
-CredentialType_Count

The report layout is assigned to the FacultyEducation table.

Sub-summary part1:  FacultyEducation::CredentialType
       Contains fields: CredentialType and CredentialType_Count
Sub-summary part2:  Faculty::Name_Last_First
       Contains fields: Name_Last_First
Body
       Contains fields: CredentialDescription
Footer

Sort order:
       FacultyEducation::CredentialType (ascending)
       Faculty::Name_Last_First (ascending)


How can I get a proper count of the Faculty ?

 

See if this helps:

http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/#entry289204

Informative but how should the sub-summary parts be setup?

Like this?

CountDistinctInCategory.fp7.zip