这个报错是哪里呢 sql: select Z1MON, SUM(BQTZL) as zl, SUM(BEHHZ) as hs from dbo.ZNMS_JIT_Z2_FXHZ_MBS WHERE 1= 1 and Z1STMP in (SELECT Z1STMP FROM dbo.ZNMS_JIT_Z2_FXHZ_MBS WHERE DATEPART(DW,Z1STMP)=2 GROUP BY Z1STMP) ${if(p_checkBox0="true", "and COMPNO not in (SELECT MATERIAL FROM dbo.ZNMS_JIT_PCH WHERE VALID IS NULL AND SUPPLIER IS NULL AND MATERIAL IS NOT NULL) and LIFNR not in (SELECT SUPPLIER FROM dbo.ZNMS_JIT_PCH WHERE VALID IS NULL AND MATERIAL IS NULL AND SUPPLIER IS NOT NULL) and not EXISTS (select 1 from dbo.ZNMS_JIT_PCH where VALID IS NULL and supplier =dbo.ZNMS_JIT_Z2_FXHZ_MBS.lifnr and MATERIAL=dbo.ZNMS_JIT_Z2_FXHZ_MBS.compno)","")} ${if(len(p_cx)==0,"","and MATKL in ( '"+p_cx+"' )")} ${if(len(p_dateEditor0)==0,"","and Z1MON >= '"+p_dateEditor0+"'")} ${if(len(p_dateEditor1)==0,"","and Z1MON <= '"+p_dateEditor1+"'")} and RGMON<= REPLACE(CONVERT(varchar(7), dateadd(month,${p_numberEditor0},Z1MON+'01'), 120),'-','') group by Z1MON order by Z1MON 用debug模式看:文件--选项--高级--log级别改成debug模式 |