我有以下查询:
SELECT TOP ( 10 )
EMPLOYEE ,
NAME ,
SUM(QTYFINISHED) AS QTY ,
SUM(HOURS) AS REALTIME ,
SUM(PROCESSTIME * QTYFINISHED / PROCESSQTY / 60) AS CALCTIME ,
SUM(PROCESSTIME * QTYFINISHED / PROCESSQTY / 60) / SUM(HOURS) AS EFFI
FROM EMPLOYEE
GROUP BY EMPLOYEE ,
NAME
ORDER BY Eficience DESC
当我在“查询设计”中执行它时,我有正确的值:
Employee Name QTY REALTIME CALCTIME EFFI
2 Peter 10 10 5 0,5
3 John 10 10 10 1
4 Thomas 10 12 9 0,75
...
但是,当我在报告的表格中添加字段时,预览会在字段之间造成一些混乱:
Employee Name QTY REALTIME CALCTIME EFFI
2 10 10 5 0,5 #Error
3 10 10 10 1 #Error
4 10 12 9 0,75 #Error
...
如果我从查询(当然还有报表)中删除“名称”字段,我将在查询设计和报表预览中获得正确的值。
注意:真正的查询包括 JOIN ,并且字段是通过表名称空间引用的,但出于可读性原因,我将其放出,因为我不认为有任何区别。