MSSQL数据库不能运行这个报表吗？

sean.qin

使用MSSQL数据查询任务相关报表时，提示错误信息。


请问下MSSQL的数据库，需要修改程序代码吗？
执行sql:  SELECT (@i:=@i+1) NONUM,P.INSTANCENAME,P.SPROCESSNAME,P.SSTATUSNAME, DATE_FORMAT(P.sActualStartTime,'%Y-%m-%d %H:%i:%s') SACTUALSTARTTIME,DATE_FORMAT(P.ActualFinishTime,'%Y-%m-%d %H:%i:%s') SACTUALFINISHTIME, TIMESTAMPDIFF(MINUTE,P.sActualStartTime, P.ActualFinishTime) SECONDSTIME, CONCAT(TIMESTAMPDIFF(DAY, P.sActualStartTime, P.ActualFinishTime),'天', MOD(TIMESTAMPDIFF(HOUR,P.sActualStartTime, P.ActualFinishTime), 24),'小时',  MOD(TIMESTAMPDIFF(MINUTE,P.sActualStartTime, P.ActualFinishTime), 60),'分钟', MOD(TIMESTAMPDIFF(SECOND,P.sActualStartTime, P.ActualFinishTime), 60),'秒') LONGTIME FROM (SELECT S.sname INSTANCENAME,S.SPROCESS,S.SPROCESSNAME, S.sStatusNAME SSTATUSNAME, S.sActualStartTime, (CASE WHEN S.sActualFinishTime IS NOT NULL  THEN S.sActualFinishTime ELSE NOW() END) ActualFinishTime FROM SA_TASK S WHERE S.sKindID = 'tkProcessInstance' )P,(select @i:=0)B WHERE 1=1 ORDER BY SECONDSTIME desc, binds: []出错
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行sql:  SELECT (@i:=@i+1) NONUM,P.INSTANCENAME,P.SPROCESSNAME,P.SSTATUSNAME, DATE_FORMAT(P.sActualStartTime,'%Y-%m-%d %H:%i:%s') SACTUALSTARTTIME,DATE_FORMAT(P.ActualFinishTime,'%Y-%m-%d %H:%i:%s') SACTUALFINISHTIME, TIMESTAMPDIFF(MINUTE,P.sActualStartTime, P.ActualFinishTime) SECONDSTIME, CONCAT(TIMESTAMPDIFF(DAY, P.sActualStartTime, P.ActualFinishTime),'天', MOD(TIMESTAMPDIFF(HOUR,P.sActualStartTime, P.ActualFinishTime), 24),'小时',  MOD(TIMESTAMPDIFF(MINUTE,P.sActualStartTime, P.ActualFinishTime), 60),'分钟', MOD(TIMESTAMPDIFF(SECOND,P.sActualStartTime, P.ActualFinishTime), 60),'秒') LONGTIME FROM (SELECT S.sname INSTANCENAME,S.SPROCESS,S.SPROCESSNAME, S.sStatusNAME SSTATUSNAME, S.sActualStartTime, (CASE WHEN S.sActualFinishTime IS NOT NULL  THEN S.sActualFinishTime ELSE NOW() END) ActualFinishTime FROM SA_TASK S WHERE S.sKindID = 'tkProcessInstance' )P,(select @i:=0)B WHERE 1=1 ORDER BY SECONDSTIME desc, binds: []出错
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more

jishuang

sql到数据库中执行看是否可以，mssql数据库就需要用msssql的语法