交叉报表显示不正确．咋回事呐

[qqf]

declare @sql varchar(8000)
set @sql = 'select kemu_id as ' + 'kemu_name'
select @sql = @sql + ' , max(case ry when ''' + ry + ''' then je else 0 end) [' + ry + ']'
from (select distinct ry from #fy) as a
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id,ry order by kemu_id,ry'
exec(@sql)

显示结果
kemu_name　　　　张三　　　　李四　　　　HJ
财务费用　　　200.00 　0.00　　　　200.00
财务费用　　　 0.00　　　155.00　　　　155.00
管理费用 40.00 0.00 40.00
管理费用 0.00 30.00 30.00

[水族杰纶]

?

[Mr_Nice]

给数据，和结果哦。

[永生天地]

用表格显示

[htl258_Tony]

declare @sql varchar(8000)  
set @sql = 'select kemu_id as ' + 'kemu_name'  
select @sql = @sql + ' , max(case ry when ''' + ry + ''' then je else 0 end) [' + ry + ']'  
from (select distinct ry from #fy) as a  
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id'  
exec(@sql)

[chuifengde]

set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id,ry order by kemu_id,ry' 

===》》
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id' 

[永生天地]

group by错了

[永生天地]

declare @sql varchar(8000)  
set @sql = 'select kemu_id as ' + 'kemu_name'  
select @sql = @sql + ' , max(case ry when ''' + ry + ''' then je else 0 end) [' + ry + ']'  
from (select distinct ry from #fy) as a  
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id'  
exec(@sql)

[冷箫轻笛]

declare @sql varchar(8000)  
set @sql = 'select kemu_id as ' + 'kemu_name'  
select @sql = @sql + ' , sum(max(case ry when ''' + ry + ''' then je else 0 end)) [' + ry + ']'  
from (select distinct ry from #fy) as a  
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id,ry'  
exec(@sql)