SHAPE
{
select cr_workshop,cr_type
,[failure(0)]=sum(case cr_failure when 0 then 1 else 0 end)
,[failure(1)]=sum(case cr_failure when 1 then 1 else 0 end)
,[failure(2)]=sum(case cr_failure when 2 then 1 else 0 end)
,[failure(3)]=sum(case cr_failure when 3 then 1 else 0 end)
,[failure(4)]=sum(case cr_failure when 4 then 1 else 0 end)
,[failure(5)]=sum(case cr_failure when 5 then 1 else 0 end)
,[failure(6)]=sum(case cr_failure when 6 then 1 else 0 end)
,[failure(7)]=sum(case cr_failure when 7 then 1 else 0 end)
,[ftotal]=sum(case when cr_failure in(1,2,3,4,5,6,7) then 1 else 0 end)
from tbl_compressor_record where convert(varchar(10),cr_date,120)='2004-08-07'
group by cr_workshop,cr_type order by cr_workshop} AS Command4
COMPUTE Command4,
SUM(Command4.'failure(0)') AS Aggregate0,
SUM(Command4.'failure(1)') AS Aggregate1,
SUM(Command4.'failure(2)') AS Aggregate2,
SUM(Command4.'failure(3)') AS Aggregate3,
SUM(Command4.'failure(4)') AS Aggregate4,
SUM(Command4.'failure(5)') AS Aggregate5,
SUM(Command4.'failure(6)') AS Aggregate6,
SUM(Command4.'failure(7)') AS Aggregate7,
SUM(Command4.'ftotal') AS Aggtotal
BY 'cr_workshop'
5 个解决方案
#1
一楼，不知为什么大家都不来啊？
#2
估计很少人用vb吧，我要不是赶时间做报表，估计也不会用这个，才研究可一个星期，很多问题不懂，但是这个版的人好像不能解决我的问题
#3
问题解决了，揭帖
#4
怎么解决的啊？
#5
你一定是变量写错了
#1
一楼，不知为什么大家都不来啊？
#2
估计很少人用vb吧，我要不是赶时间做报表，估计也不会用这个，才研究可一个星期，很多问题不懂，但是这个版的人好像不能解决我的问题
#3
问题解决了，揭帖
#4
怎么解决的啊？
#5
你一定是变量写错了