Question

如何在birt中设置参数为SQL来实现过滤

如何在birt中设置参数为SQL语句来实现过滤？

Answer 1

是这样写的：

mysql> select sum(callcost) sumcallcost,
-> sum(duration) sumduration,
-> sum(chargeclass) sumchargeclass,
-> sum(acrtype) sumacrtype
-> from
-> (
-> select callcost, duration,chargeclass, acrtype
-> from acr_record
-> limit 1,10
-> ) a ;

Answer 2

56789874