我做了一个报表如下:为什么小计时总要把上面的小计加上来呢?请看仓库号    账本号        物资编码         库存数量       库存金额
___________________________________________________________________
01          01        
___________________________________________________________________
                         01-01-001          10             10
                         01-01-002          20             30
                         01-01-003          2              10
___________________________________________________________________
小计                                        32             50 
____________________________________________________________________
01           02 
_____________________________________________________________________
                         01-02-001          10             10
                         01-02-002          0              0
                         01-02-003          2              10   
___________________________________________________________________
小计                                        44             70
___________________________________________________________________
02          01        
___________________________________________________________________
                         02-01-001          10             10
                         02-01-002          10             20
                         02-01-003          10             10
___________________________________________________________________
小计                                        74             110
____________________________________________________________________
  
合计                                        74             110
应该是这样才对呀。仓库号    账本号        物资编码         库存数量       库存金额
___________________________________________________________________
01          01        
___________________________________________________________________
                         01-01-001          10             10
                         01-01-002          20             30
                         01-01-003          2              10
___________________________________________________________________
小计                                        32             50 
____________________________________________________________________
01           02 
_____________________________________________________________________
                         01-02-001          10             10
                         01-02-002          0              0
                         01-02-003          2              10   
___________________________________________________________________
小计                                        12             20
___________________________________________________________________
02          01        
___________________________________________________________________
                         02-01-001          10             10
                         02-01-002          10             20
                         02-01-003          10             10
___________________________________________________________________
小计                                        30             40
____________________________________________________________________
  
合计                                        74             110各位看出了什么问题
我是用quickrep来做的
具体的做法如下:
   创建一个报表,在其上面放二个qrband, 一个qrgroup1,一个subedail
设置quickrep的 hascolumnheader 为true, hasdetail为 true,
放一个adoquery做为数据库联接,qrgoup1的 expression 为 账本号
masker 为qrsubdetail,subdetail的 footerband为qrband1 ,qrband2上一个qrexpr1做为统计小计,其maseter为:subdetail,
在qrband1上为一个qrexpr2做为统计合计,其maseter为:subdetail
解决了别加200分
我希望哪一位能帮我这个问题,分不够以后另开贴加分,并请留下EMAIL我发给他源程序,帮我修改,谢谢.

解决方案 »

  1.   

    我可以看一下,但是不保证一定能改好:)
    [email protected]
      

  2.   

    看一看这个属性,可能可以解决你的问题
    QRExpr1.resetafterprint:=true;
      

  3.   

    如果你用EXCEL来做的话,
    问题就变得简单了。
      

  4.   

    [email protected]
    我以前做过。应该是没问题的。
      

  5.   

    定義四個變量﹕二個小計變量﹐二個總計變量.01          01        
    ___________________________________________________________________
                             01-01-001          10           10
                             01-01-002          20           30 band beforeprint
                             01-01-003          2            10 二個變量將其累加合計
    ___________________________________________________________________
    小计                                        32           50   band beforeprint
                                                                  賦給二個總計變量
                                                                  小計變量清0
      

  6.   

    我遇到的问题和你的差不多,把你的代码给我发一分,我看看
    综合一下,看看能不能有新的发现hbwjz2163.com
      

  7.   

    同意冰河的 定义不同的变量
    [email protected]
      

  8.   

    采用fastreport就可以解决问题了,不用什么任何的代码, 要的话,发email给我[email protected]
    我改完再给你发过去!!