Answers.Body: <p>This sounds like a bug. If you look in CRM/Case/BAO/Case.php in getCaseRoles() it has this in the SQL:</p>
  
  <p>LEFT JOIN  civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )</p>
  
  <p>If you change it to</p>
  
  <p>LEFT JOIN  civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id AND civicrm_email.is_primary = 1)</p>
  
  <p>does that fix it?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-27T15:45:01.120Z
Answers.LastActivityDate: 2015-06-27T15:45:01.120Z
Answers.UserDisplayName: Demerit
Body: <p>The Case Report presented when the Print Report link is selected does not present the primary email for the Case Manager when the Case Manager has more than one email. Should it present the primary email as it does in the Client Relationships Section of the report or is there a reason it presents a different email?</p>
  
Tags: <civicase>
Title: Which email address should the printed Case Report present for the Case Manager in the Role Section of the Report?
ThreadText: # Which email address should the printed Case Report present for the Case Manager in the Role Section of the Report?
  
  (Asked by: username_0 on 2015-06-26)
  
  The Case Report presented when the Print Report link is selected does not present the primary email for the Case Manager when the Case Manager has more than one email. Should it present the primary email as it does in the Client Relationships Section of the report or is there a reason it presents a different email?
  
  **Tags:** civicase
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-06-27. Score: 1 | Accepted answer
  
  This sounds like a bug. If you look in CRM/Case/BAO/Case.php in getCaseRoles() it has this in the SQL:
  
  LEFT JOIN civicrm\_email ON (civicrm\_email.contact\_id = civicrm\_contact.id )
  
  If you change it to
  
  LEFT JOIN civicrm\_email ON (civicrm\_email.contact\_id = civicrm\_contact.id AND civicrm\_email.is\_primary = 1)
  
  does that fix it?
  
  
  ---
  
  