SELECT DISTINCT(participants.ID) AS ID, participants.FirstName, participants.LastName, participants.Email, participants.PrimaryColor, participants.ColorAssigned, participants.GroupAssigned, participant_module_links.ModuleID, modules.ModuleName FROM participants, participant_module_links, modules WHERE participants.ProjectID = '#Client.ProjectID#' AND participant_module_links.ParticipantID = participants.ID AND modules.ID = participant_module_links.ModuleID ORDER BY modules.ModuleName,participants.LastName, participants.FirstName SELECT DISTINCT(participants.ID) AS ID FROM participants, participant_module_links WHERE participants.ProjectID = '#Client.ProjectID#' AND participant_module_links.ParticipantID = participants.ID ICS-CONNECT ADMINISTRATION - PARTICIPANTS WITH MODULES BY MODULE NAME



#GetMembers.ModuleName#
Participant Energy Preference
Click to display their profile report.+ #GetMembers.LastName#, #GetMembers.FirstName# Click to send this participant an e-mail.
style="color:white;" > #GetMembers.PrimaryColor# Incomplete style="color:white;" > #GetMembers.GroupAssigned#  
Total Participants with Modules: #NumberFormat(GetCnt.RecordCount, '999,999')#
LEGEND:   Click on this icon to send an e-mail to the contact for that project. - E-mail to Participant Link     Click on this icon to display this person's profile report - Display Profile Report     + - Has Modules