解决方案: |
--脚本属性:通用(问题号:62810)
适用版本:850,850sp,851,851a,852
--在业务账套执行
declare @ID int
begin
set @ID = (select ID from rpt_glbdef where systemid='st' and name='入库调整单列表')
update rpt_fltdef
set expression='select cRDCode 收发类别编码,cRdName AS 收发类别名称 from RD_Style where bRdFlag = 1 and bRdEnd = 1' where ID=@ID and Name='cRdName' and ModeEx=1
update rpt_fltdef
set Expression='select cRDCode 收发类别编码,cRdName AS 收发类别名称 from RD_Style where bRdFlag = 1 and bRdEnd = 1' where ID=@ID and Name='cRdCode' and ModeEx=1 end
go
执行前请做好备份。 |