汇总类型没有按成本对象和物料汇总，试着写了下，用查询分析工具的直接sql报表直接输入，关键字要维护下，年度@Year@，期间@mouth@类型为字符串

if OBJECT_ID('tempdb..#wuliao') is not null drop table #wuliao;

if OBJECT_ID('tempdb..#newling') is not null drop table #newling;

select icstockbillentry.FInterID as'单据内码',

 datename(year,icstockbill.fdate)as'年度',

 datename(MONTH,icstockbill.fdate)as'期间',

 FItemID,

 FQty,

 FCostOBJID into #newling

 from ICStockBillEntry 

 left join ICStockBill on ICStockBillentry.FInterID=ICStockBill.FInterID

 where ICStockBill.ftrantype='24';

select * into #wuliao from t_Item where FItemClassID='2001';

select isnull(#wuliao.fname,'研发领料') as '成本对象',

t_Item.FNumber as '物料代码',

t_item.fname as '物料名称',

SUM(#newling.fqty) as '数量'

from #newling

left join t_Item on #newling.fitemid=t_item.FItemID

left join #wuliao on #newling.fcostobjid=#wuliao.fitemid

where 年度='@Year@' AND 期间='@mouth@'

group by #wuliao.fname,t_Item.FNumber,t_item.fname;