select administrator_code,sum(trade_quantity) as total_trade_quantity from SALE_DATA group by administrator_code
用sql语句生成一个数据集Query1,再把报表和该数据集关联就行了 sql语句: select t1.administrator_code,SUM(t1.trade_quantity) as total_trade_quantity form SALE_DATA as t1,ADMINISTRATORS as t2 where t1.administrator_code=t2.administrator_code group by t1.administrator_code
sql语句:
select t1.administrator_code,SUM(t1.trade_quantity) as total_trade_quantity
form SALE_DATA as t1,ADMINISTRATORS as t2
where t1.administrator_code=t2.administrator_code
group by t1.administrator_code