Log in as admin Navigate to Courses > Course custom fields in site administration Press Add a new category if none exists Create two new Short text fields: Name / Short name: cfield1 Name / Short name: cfield2 Create a new course Course full name: C1 cfield1: Orange cfield2: Carrot Create a second course: Course full name: C2 cfield1: Red cfield2: Apple Navigate to Development > Debugging in site administration Set Debug messages to Developer Navigate to Reports from user menu Create new report from Courses report source Ensure Include default setup is unchecked In report editor, add the following columns: Course > Course full name Course > cfield2 Confirm full name of each course, along with value of cfield2 field is shown Add Course > cfield2 condition Is equal to: Carrot Apply Confirm only first course(C1) & Carrot are shown Expand report Debug info Confirm the { customfield_data } table is joined only once in the report Add Course > cfield1 column Confirm first course(C1), Carrot and Orange are shown Expand report Debug info Confirm the { customfield_data } table is now joined twice in the report (once per field) Add Course > cfield1 condition Is equal to: Orange Apply Confirm first course, Carrot and Orange are shown Expand report Debug info Confirm the { customfield_data } table is still joined twice in the report (once per profile field)