我有以下查询:
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,并且字段是使用表命名空间引用的,但出于可读性原因,我省略了它,因为我不认为会有任何区别。