求助一种报表的形式
ardeb 2007-11-02 11:30:30 create table t1(A varchar(10),B varchar(50),C varchar(50),D int,E varchar(50),F varchar(50),G varchar(50) )
insert t1 select
'aa','aa001','aa100',100 ,'SS','DD','FF' insert t1 select
'aa','aa101','aa200',100,'FF','GG','DD' insert t1 select
'cc','cc101','cc200',100,'FF','GG','DD' insert t1 select
'aa','aa201','aa300',100,'FF','GG','DD' insert t1 select
'cc','cc201','cc300',100,'FF','GG','DD'
create table t2 (A varchar(10),B varchar(50),C varchar(50),D int )
insert t2 select
'aa','aa001','aa200',200 insert t2 select
'cc','cc101','cc200',100
我用的是VB6.0
怎么写一个程序在MSHFlexGrid或DataGrid显示这样结果:
A,B,C,D
+ aa,aa001,aa200,200 't2的内容
+ cc,cc101,cc200,100
...
'+'这个符号下面的内容是t1的符合t2条件的内容:
点击aa的'+'显示的内容是:
aa,aa001,aa100,100,SS,DD,FF
aa,aa101,aa200,100,FF,GG,DD
点击cc的'+'显示的内容是:
cc,cc101,cc200,100,FF,GG,DD
这样的实现怎么实现啊?/求救啊!!!