在一张报表中三个相同明细,如下报表:
                         
客户名称:aaaaaa
客户地址:aaaaaaa
 月报表                      年报表
ID       NAME      消费1      消费2              消费1        消费2 1   
2         学生2       356      382                  57635       13567
3         学生3       357      842                  57535       13567
4         学生4       575      1436                 35735       13567
5         学生5       839      4682                 835735      413567
6         学生6       869      4682                 75735       513567
**********************************************************************
合计:123456789
客户名称:aaaaaa
客户地址:aaaaaaa
 月报表                      年报表
ID       NAME      消费1      消费2              消费1        消费2 1   
2         学生2       356      382                  57635       13567
3         学生3       357      842                  57535       13567
4         学生4       575      1436                 35735       13567
5         学生5       839      4682                 835735      413567
6         学生6       869      4682                 75735       513567
**********************************************************************
合计:123456789
客户名称:aaaaaa
客户地址:aaaaaaa
 月报表                      年报表
ID       NAME      消费1      消费2              消费1        消费2 1   
2         学生2       356      382                  57635       13567
3         学生3       357      842                  57535       13567
4         学生4       575      1436                 35735       13567
5         学生5       839      4682                 835735      413567
6         学生6       869      4682                 75735       513567
**********************************************************************
合计:123456789

解决方案 »

  1.   

    在SQL查询得到记录集时处理:create table #t (i int)
    insert #t select 1 union select 2 union select 3select a.* from your_table a , #t
      

  2.   

    能不能在报表中设置比如说把下面的报表画三次?客户名称:aaaaaa
    客户地址:aaaaaaa
     月报表                      年报表
    ID       NAME      消费1      消费2              消费1        消费2 1   
    2         学生2       356      382                  57635       13567
    3         学生3       357      842                  57535       13567
    4         学生4       575      1436                 35735       13567
    5         学生5       839      4682                 835735      413567
    6         学生6       869      4682                 75735       513567
    **********************************************************************
    合计:123456789
      

  3.   

    不用啊,你先用SQL查询月报表和年报表信息(“两个表查询”)然后把记录集推进报表就可以了。如datareport1.datasource=rst(记录集)