# Modifying Stock Employee Efficiency Report

**Category:** [Epicor ERP 9](https://www.epiusers.help/c/e9/7)
**Created:** 2016-11-23 19:30 UTC
**Views:** 795
**Replies:** 1
**URL:** https://www.epiusers.help/t/modifying-stock-employee-efficiency-report/36411

---

## Post #1 by @ajones

I need some help modifying the Employee Efficiency report. They want to add a formula for their calculation of efficiency but they want to use the PayHours over the direct and indirect hours. I haven't been able to successfully figure out how to get the PayHours in there from LaborHed. I created a duplicate data definition and linked LaborHed to the EmpEfficiencyDtl through the EmpID and EmployeeNum, but that doesn't appear to be the correct approach. When I run the report it either doesn't show any data or it sums the hours from the beginning of time rather than the current date range I'm looking at.

Thoughts?

---

## Post #2 by @bordway

I think you're going to be stuck build a BAQ report.

The RDD EmpEfficiency is using a temp table "EmpEfficientcyDtl"
Unfortunately we aren't able to add relationships to temp tables in an RDD.

---


**Canonical:** https://www.epiusers.help/t/modifying-stock-employee-efficiency-report/36411
**Original content:** https://www.epiusers.help/t/modifying-stock-employee-efficiency-report/36411