水晶报表SQL语句如何改变，如select rcode,rname,amount from t1 group by gpc,gpb,gpc order by

[jeetliang]

如select rcode,rname,amount from t1 group by gpc,gpb,gpa order by gpc,gpb,gpa

如果按gpc,gpb,gpa 三个分组，好象就一定要按这三个排序（order by gpc,gpb,gpa)
我现在不想按这三个排序，如何得到这样的语句

select rcode,rname,amount from t1 group by gpc,gpb,gpa order by gpa，rcode

[jeetliang]

啊！没人会吗？不会吧！加分！

[kssys]

根據你寫的SQL，應該是這樣吧:

SELECT rcode,rname,Sum(amount) AS Amount
FROM t1
GROUP BY gpc,gpb,gpa ,rCode,rName
ORDER BY gpa，rcode

[Yellow198267]

尚在研究.........

[jeetliang]

难道真的不能改吗？？？那用水晶报表就有麻烦了，这是很基本的功能！

[jeetliang]

有没有研究出来啊，兄弟们！