Answers.Body: <p>Check out Lola Slade's excellent CiviCon presentations on this topic:  <a href="https://denver2015.civicrm.org/sessions/civicrm-custom-reports-101" rel="nofollow">2015 session</a> (download the PDF on this page); <a href="https://www.youtube.com/watch?v=WlGovqePUiw&amp;list=PLjSU7YfE0E01HW7JPVAI80XDI0sgOSPDs&amp;index=5" rel="nofollow">2015 video</a>, and the <a href="http://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Reports-Customize%20and%20Extend.pdf" rel="nofollow">CiviCon 2012</a> slideshow.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-31T03:30:42.280Z
Answers.LastActivityDate: 2015-07-31T03:30:42.280Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have built a report off of the Activity Report template and have been able to add all the columns I need EXCEPT target contact phone number. Email and many address fields are available in the "columns" tab but I do not see phone number there. </p>
  
  <p>Is there anything I can do to expose this information?</p>
  
  <p>(I thought about using a Constituent Report (Detail) instead, because phone is available there--but I want to filter by activity type and include custom fields on my activities.)</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-31T03:31:26.623Z
Comments.Text: Hey Lisa!  I gave an answer below - but if you want to work through this together, contact me privately via e-mail.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-03T17:10:55.300Z
Comments.Text: Thanks so much, Jon! I will check this out and reach out if nec.
Comments.UserDisplayName: Lisa J
Tags: <civireport><activities>
Title: How can I modify the Activity Report to display phone number?
ThreadText: # How can I modify the Activity Report to display phone number?
  
  (Asked by: username_0 on 2015-07-30)
  
  I have built a report off of the Activity Report template and have been able to add all the columns I need EXCEPT target contact phone number. Email and many address fields are available in the "columns" tab but I do not see phone number there.
  
  Is there anything I can do to expose this information?
  
  (I thought about using a Constituent Report (Detail) instead, because phone is available there--but I want to filter by activity type and include custom fields on my activities.)
  
  **Tags:** civireport, activities
  
  > **Comments:**
  > **username_1**: Hey Lisa!  I gave an answer below - but if you want to work through this together, contact me privately via e-mail.  
  > **username_0**: Thanks so much, Jon! I will check this out and reach out if nec.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-07-31. Score: 0 | Accepted answer
  
  Check out Lola Slade's excellent CiviCon presentations on this topic: [2015 session](https://denver2015.civicrm.org/sessions/civicrm-custom-reports-101) (download the PDF on this page); [2015 video](https://www.youtube.com/watch?v=WlGovqePUiw&list=PLjSU7YfE0E01HW7JPVAI80XDI0sgOSPDs&index=5), and the [CiviCon 2012](http://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Reports-Customize%20and%20Extend.pdf) slideshow.
  
  
  ---
  
  