select * from ck_deposit_info where deposit_amount<>0
order by convert(char,deposit_time,112)
compute sum(deposit_amount) by convert(char,deposit_time,112)card_no worker_id worker_name rest_amount deposit_amount deposit_time oper_id
000001 001 胡砚均 .0000 200.0000 2003-01-16 11:18:49.280 311
001135 .0000 100.0000 2003-01-16 13:48:43.660 311
000504 504 褚金辉 .0000 100.0000 2003-01-16 14:23:30.830 311
000309 309 周国芬 .0000 100.0000 2003-01-16 14:24:39.590 311
000218 218 李剑 .0000 100.0000 2003-01-16 14:43:47.980 311
sum
600.0000
试问如何用QUICKREP做成与上面格式一致的报表?(也就是说对每天的金额有一个小计),谢谢!
order by convert(char,deposit_time,112)
compute sum(deposit_amount) by convert(char,deposit_time,112)card_no worker_id worker_name rest_amount deposit_amount deposit_time oper_id
000001 001 胡砚均 .0000 200.0000 2003-01-16 11:18:49.280 311
001135 .0000 100.0000 2003-01-16 13:48:43.660 311
000504 504 褚金辉 .0000 100.0000 2003-01-16 14:23:30.830 311
000309 309 周国芬 .0000 100.0000 2003-01-16 14:24:39.590 311
000218 218 李剑 .0000 100.0000 2003-01-16 14:43:47.980 311
sum
600.0000
试问如何用QUICKREP做成与上面格式一致的报表?(也就是说对每天的金额有一个小计),谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货