# Activity reporting by user

**URL:** <https://www.dolibarr.org/forum/t/activity-reporting-by-user/16681>\
**Category:** Using my Dolibarr\
**Tags:** Reports\
**Created:** [June 4, 2018, 10:56am UTC](https://www.dolibarr.org/forum/t/activity-reporting-by-user/16681 "2018-06-04T10:56:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![secretsgarden](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/7993a0/32.png) [@secretsgarden](https://www.dolibarr.org/forum/u/secretsgarden)\
**Post date:** [June 4, 2018, 10:56am UTC](https://www.dolibarr.org/forum/t/activity-reporting-by-user/16681/1 "2018-06-04T10:56:06Z")

</div>

Hi !

Every user uses the agenda to report their activity (visits, calls, etc…).

Now, I would like to get an activity report by user, this can be a weekly or monthly report…for instance for a salesman…

In Agenda/report, it only gives a report of all the activities by all the users…

Any idea on how to get this ?

Thanks for your help

Eric

---

<div class="post-metadata">

**Author:** ![delcroip](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@delcroip](https://www.dolibarr.org/forum/u/delcroip)\
**Post date:** [June 5, 2018, 1:27pm UTC](https://www.dolibarr.org/forum/t/activity-reporting-by-user/16681/2 "2018-06-05T13:27:57Z")

</div>

Hi,

a code change is required in the comm/action/rapport/index.php

A quick & durty way is to show only the activity of the connected user:  
line 79  
$sql = “SELECT count(\*) as cc,”;  
$sql.= " date\_format(a.datep, ‘%m/%Y’) as df,";  
$sql.= " date\_format(a.datep, ‘%m’) as month,";  
$sql.= " date\_format(a.datep, ‘%Y’) as year";  
$sql.= " FROM “.MAIN\_DB\_PREFIX.“actioncomm as a,”;  
$sql.= " “.MAIN\_DB\_PREFIX.“user as u”;  
$sql.= " WHERE a.fk\_user\_author = ".$user-\>id.’ ';  
$sql.= ’ AND a.entity IN (’.getEntity(‘agenda’).’)’;  
//$sql.= " AND percent = 100”;  
$sql.= " GROUP BY year, month, df”;  
$sql.= " ORDER BY year DESC, month DESC, df DESC";

br

---

<div class="post-metadata">

**Author:** ![delcroip](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@delcroip](https://www.dolibarr.org/forum/u/delcroip)\
**Post date:** [June 5, 2018, 1:29pm UTC](https://www.dolibarr.org/forum/t/activity-reporting-by-user/16681/3 "2018-06-05T13:29:48Z")

</div>

hi,

Anyway don’t hesitate to create a feature request on the github:[https://github.com/Dolibarr/dolibarr/issues](https://github.com/Dolibarr/dolibarr/issues)

br