水晶报表的字段可以轻松打印,但是如果是SQL语句中的比如SUM()函数非表字段的内容能打印么?如下语句应该怎么做呢?谢谢!
SELECT EMPNAME, SUM(REVARD) FROM ENROL GROUP BY EMPNAME ORDER BY SUM(REVARD) ASC
SELECT EMPNAME, SUM(REVARD) FROM ENROL GROUP BY EMPNAME ORDER BY SUM(REVARD) ASC
--把SUM(REVARD) 当成一个字段,在打印的时候打印这个字段就OKSELECT EMPNAME, SUM(REVARD)REVARD FROM ENROL GROUP BY EMPNAME
ORDER BY SUM(REVARD) ASC