用Reporting Services 做分类报表

效果图

部门领料明细汇总表
类别	仓库	单位	PD1部				PD6部
			包装组	返工组	装配组		包装材料组	全新装组	试产组
芯片	0	pcs		-16979
	130	pcs	-3298		0		2	0	0
杂项-包装物	141	pcs	126	0	0		1	0	0
纸盒	141	pcs	721029	-16979	0		214541	0	0

 

create table testa( id int identity(1,1),
dept nvarchar(10) ,team nvarchar(20),stype nvarchar(20),valu int
,store nvarchar(10),unit nvarchar(10)
)


--select * from testa
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','装配组' ,'杂项-包装物','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','包装组' ,'杂项-包装物','126','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','返工组' ,'杂项-包装物','0','141','pcs')

insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','试产组' ,'杂项-包装物','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','全新装组' ,'杂项-包装物','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','包装材料组' ,'杂项-包装物','1','141','pcs')

insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','装配组' ,'纸盒','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','包装组' ,'纸盒','721029','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','返工组' ,'纸盒','-16979','141','pcs')

insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','试产组' ,'纸盒','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','全新装组' ,'纸盒','0','141','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','包装材料组' ,'纸盒','214541','141','pcs')
--
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','装配组' ,'芯片','0','130','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','包装组' ,'芯片','-3298','130','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD1部','返工组' ,'芯片','-16979','0','pcs')

insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','试产组' ,'芯片','0','130','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','全新装组' ,'芯片','0','130','pcs')
insert into testa ( dept,team, stype,valu ,store,unit)
values('PD6部','包装材料组' ,'芯片','2','130','pcs')