# Customize Report - Patient List

**URL:** <https://community.open-emr.org/t/customize-report-patient-list/2301>\
**Category:** Management and Administration\
**Created:** [July 15, 2009, 3:34pm UTC](https://community.open-emr.org/t/customize-report-patient-list/2301 "2009-07-15T15:34:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 15, 2009, 3:34pm UTC](https://community.open-emr.org/t/customize-report-patient-list/2301/1 "2009-07-15T15:34:36Z")

</div>

**[docaltmed](https://sourceforge.net/u/docaltmed/)** wrote on [Wednesday, July 15, 2009](https://sourceforge.net/p/openemr/discussion/202505/thread/ecbecad2/#557d):

How would I customize the Patient List report to replace the "work phone" field with the "email" field?

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [July 17, 2009, 2:36pm UTC](https://community.open-emr.org/t/customize-report-patient-list/2301/2 "2009-07-17T14:36:49Z")

</div>

**[cfapress](https://sourceforge.net/u/cfapress/)** wrote on [Friday, July 17, 2009](https://sourceforge.net/p/openemr/discussion/202505/thread/ecbecad2/#557d/170c):

Look at the file  
\<oemr\>/interface/reports/patient\_list.php

Then around line 157, where the SQL query is specified, add this line  
"p.email,".

Next, you need to alter the code that outputs the table headers, around line 148 you’ll see something like this  
&nbsp; \<th\> \<?php xl(‘Work Phone’,‘e’); ?\> \</th\>  
change it to  
&nbsp; \<th\> \<?php xl(‘Email’,‘e’); ?\> \</th\>

Finally, you need to alter the code that outputs the results of the query. Around line 226 look for this line:  
&nbsp;&nbsp; \<?php echo $row[‘phone\_biz’] ?\>  
and change it to  
&nbsp; \<?php echo $row[‘email’] ?\>

That should do the trick.

Jason