query1的sql為
select outdate,price,sum(qty) as qty ,sum(qty*price) as amount
from out
group by outdate,price
quickreport分組(outdate)之後,groupfooter的QrExr有Expersion為 sum(query1.qty),記錄分組正确,但結果會把之前的qty全部加起來例第二組組尾的會將第一,二組的qty全部加總.
select outdate,price,sum(qty) as qty ,sum(qty*price) as amount
from out
group by outdate,price
quickreport分組(outdate)之後,groupfooter的QrExr有Expersion為 sum(query1.qty),記錄分組正确,但結果會把之前的qty全部加起來例第二組組尾的會將第一,二組的qty全部加總.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货