Jason H Posted May 9, 2014 Posted May 9, 2014 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 ?
comment Posted May 9, 2014 Posted May 9, 2014 See if this helps: http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/#entry289204
Jason H Posted May 12, 2014 Author Posted May 12, 2014 Informative but how should the sub-summary parts be setup?
Recommended Posts
This topic is 4100 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now