Contact Subtype field at Reports does not support contacts with multiple subtypes
How to reproduce:
- open "Reports > Contact Reports > Constituent Summary" report
- click "Filters" tab
- select "Is one of" for "Contact Subtype" field
- choose subtype "Student"
- click "Refresh results" button
- look at results: There are contacts which have only one subtype "Student"
- click "Developer" tab
- look at WHERE clause
contact_civireport.contact_sub_type IN ('Student')
This condition should looks like this:
contact_civireport.contact_sub_type LIKE '%Student%'