费心帮忙看看compute sum label '合计' of
ttitle center '5月厂商别单品销售前50名' col50 right'页号:' sql.pno skip 4-left'厂编:' suppl_no col20 '名称:' name col80 '采购:' buyer_uid col100 '类型:' suppl_type col185 skip 2
column c0 noprint new_value suppl_no
column c1 noprint new_value name
column c2 noprint new_value buyer_uid
column c3 noprint new_value suppl_type
col c4 hea '排名' for 99
col c5 hea '货号' for 999999
col c6 hea '描述' for A34
col c7 hea '状态' for 9
col c8 hea 'DMS' for 999.99
col c9 hea '库存数量' for 999,999.99
col c10 hea '在线定量' for 999999
col c11 hea '月销售金额' for 999999,999.99
col c12 hea '月销量' for 999999
col c13 hea '毛利额' for 9999,999.99
col c14 hea '毛利率' for 99.99
break on c0skip page
compute sum label '汇总' of c11 on c0
compute sum label '汇总' of c12 on c0
compute sum label '汇总' of c13 on c0
set pagesize 80
set linesize 180
set verify off
set feedback off
set termout off
spool monthsale.200705
select c.suppl_no c0,a.name c1,a.buyer_uid c2,a.suppl_type c3,c.no c4,c.art_no c5,b.descr c6,b.art_status c7,b.dms c8,
b.stock c9,b.on_order c10,c.amount c11,c.qty c12,c.ml_amount c13,(c.ml_amount/c.amount)*100 c14
from supplier@headof a,article b,t1_tmp c
where c.suppl_no=a.suppl_no
and c.art_no=b.art_no
and c.amount>0
order by c.suppl_no,c.no,c.amount;
spool off;
不显示'汇总'这两个字，求和值能计算出来，但不用label也不显示sum,请各位大侠救命啊！！！
运行环境是unixware 7.1.3 ;oracle 7
[ 本帖最后由 albert_wn 于 2007-7-6 14:21 编辑 ] 不要 c0 noprint
noprint 就不显示lable 了 谢谢啊！以后还请多多指教！！！再次表示感谢！ 本帖最后由 zgandyli 于 2012-10-08 11:52 编辑
break on c0skip page
compute sum label '汇总' of c11 on c0
compute sum label '汇总' of c12 on c0
compute sum label '汇总' of c13 on c0
以上三句改为：
break on c0 on report
compute sum label'合计' of c11 c12 c13 on c0 report
页:
[1]