Reprot怎么做正交表？

chirsdong

谢谢 player012 共享！有空看！:rose

jiao88

最初由 player012 发布
[B]hope it can help you. [/B]

正在學這方面的，謝謝提供

demmy

经测试，结果错误

gongtai

Oracle Report Bulider 好像无法完成复杂的报表结构呀

gongtai

看了player012兄共享的.rdf文件，有一点想请教一下，这个报表的循环矩陈如何实现叠加的呢，不明之处还望不吝赐教。

ttx2000

最初由 player012 发布
[B]hope it can help you. [/B]

player012可否把test_crosstab的结构及内容贴出来看看啊

player012

drop table test_crosstab;

create table test_crosstab (province varchar2(100), city varchar2(100), year varchar2(4), quantity number(15));


insert into test_crosstab values ('江西','九江','1997',1);

insert into test_crosstab values ('江西','南昌','1997',1);

insert into test_crosstab values ('江西','南昌','1997',1);

insert into test_crosstab values ('江西','九江','1998',1);

insert into test_crosstab values ('江西','九江','1998',2);

insert into test_crosstab values ('江西','南昌','1998',5);

insert into test_crosstab values ('江西','南昌','1998',6);

insert into test_crosstab values ('湖北','武汉','1997',3);

insert into test_crosstab values ('湖北','武汉','1997',4);

insert into test_crosstab values ('湖北','武汉','1997',5);

insert into test_crosstab values ('湖北','武汉','1997',4);

insert into test_crosstab values ('湖北','仙桃','1997',1);

insert into test_crosstab values ('湖北','仙桃','1997',2);

insert into test_crosstab values ('湖北','仙桃','1997',10);

insert into test_crosstab values ('湖北','孝咸','1997',11);

insert into test_crosstab values ('湖北','孝咸','1997',7);

insert into test_crosstab values ('湖北','孝咸','1997',6);

insert into test_crosstab values ('湖北','武汉','1998',3);

insert into test_crosstab values ('湖北','武汉','1998',9);

insert into test_crosstab values ('湖北','仙桃','1998',1);

insert into test_crosstab values ('湖北','孝咸','1998',18);

insert into test_crosstab values ('湖北','孝咸','1998',5);

commit;