数据集预览没有问题，但是预览报表以查询就提示语法错误。

select   CONVERT (date,left(CREATE_DATE,8)) 日期,

case when TC004='5104' then '冲压' when TC004='5105' then '冷镦' 

when TC004='5106' then '高频' when TC004='5107' then '磨刀' 

when TC004='5102' then '自动化' when TC004='5101' then '锯链包装' end 工序,

(TC004+'-'+TC005) 工单号,sum(convert(float,TC014)) 数量 

from SFCTC  where TC004 in('5104','5106','5102','5105','5107','5101')

group by TC004,TC005,CONVERT (date,left(CREATE_DATE,8))

${if(len(开始日期)==0,"","and CONVERT(date,left(CREATE_DATE,8)) >= ('"+开始日期+"')")}

${if(len(结束日期)==0,"","and CONVERT(date,left(CREATE_DATE,8)) <= ('"+结束日期+"')")}