Issues with query processing

Query

SELECT DATENAME(month, DATEADD(mm, -1, GETDATE())) + ' ' + DATENAME(year, GETDATE()) AS [ ]

,ordercount AS 'Total Completed'

,ordercount - overdue AS "Completed Within SLA"

,CONVERT(DECIMAL(5, 2), ( CONVERT(FLOAT, ordercount) - CONVERT(FLOAT, overdue) ) / ordercount * 100) AS "% Completed Within SLA"

FROM ( SELECT COUNT(*) AS ordercount

,SUM(CASE WHEN wos.ISOVERDUE = 1 THEN 1

ELSE 0

END) AS [Overdue]

FROM WorkOrder wo

LEFT JOIN WorkOrder_Queue woq

ON wo.WORKORDERID = woq.WORKORDERID

LEFT JOIN QueueDefinition qd

ON woq.QUEUEID = qd.QUEUEID

LEFT JOIN WorkOrderStates wos

ON wo.WORKORDERID = wos.WORKORDERID

WHERE qd.QUEUEID IN ( 601, 602 )

AND ( ( ( wo.COMPLETEDTIME >= CONVERT(BIGINT, STR(CAST(DATEDIFF(s, '19700101',

DATEADD(MONTH,

DATEDIFF(MONTH, 0, GETDATE())

- 1, 0)) AS FLOAT) * 1000,

13, 1)) )

AND ( ( wo.COMPLETEDTIME != 0 )

AND ( wo.COMPLETEDTIME IS NOT NULL )

)

AND ( ( wo.COMPLETEDTIME <= CONVERT(BIGINT, STR(CAST(DATEDIFF(s, '19700101',

DATEADD(hh, 23,

DATEADD(mi, 59,

DATEADD(ss, 59,

DATEADD(ms, 997,

DATEADD(MONTH,

DATEDIFF(MONTH,

-1, GETDATE())

- 1, -1)))))) AS FLOAT)

* 1000, 13, 1)) )

AND ( ( ( wo.COMPLETEDTIME != 0 )

AND ( wo.COMPLETEDTIME IS NOT NULL )

)

AND ( wo.COMPLETEDTIME != -1 )

)

AND wo.ISPARENT = 1

) p

UNION ALL

SELECT DATENAME(month, DATEADD(mm, -1, GETDATE())) + ' ' + DATENAME(year, DATEADD(yy, -1, GETDATE())) AS [ ]

,ordercount AS 'Total Completed'

,ordercount - overdue AS "Completed Within SLA"

,CONVERT(DECIMAL(5, 2), ( CONVERT(FLOAT, ordercount) - CONVERT(FLOAT, overdue) ) / ordercount * 100) AS "% Completed Within SLA"

FROM ( SELECT COUNT(*) AS ordercount

,SUM(CASE WHEN wos.ISOVERDUE = 1 THEN 1

ELSE 0

END) AS [Overdue]

FROM WorkOrder wo

LEFT JOIN WorkOrder_Queue woq

ON wo.WORKORDERID = woq.WORKORDERID

LEFT JOIN QueueDefinition qd

ON woq.QUEUEID = qd.QUEUEID

LEFT JOIN WorkOrderStates wos

ON wo.WORKORDERID = wos.WORKORDERID

WHERE qd.QUEUEID IN ( 601, 602 )

AND ( ( ( wo.COMPLETEDTIME >= CONVERT(BIGINT, STR(CAST(DATEDIFF(s, '19700101',

DATEADD(yy, -1,

DATEADD(MONTH,

DATEDIFF(MONTH, 0,

GETDATE()) - 1,

0))) AS FLOAT)

* 1000, 13, 1)) )

AND ( ( wo.COMPLETEDTIME != 0 )

AND ( wo.COMPLETEDTIME IS NOT NULL )

)

AND ( ( wo.COMPLETEDTIME <= CONVERT(BIGINT, STR(CAST(DATEDIFF(s, '19700101',

DATEADD(yy, -1,

DATEADD(hh, 23,

DATEADD(mi, 59,

DATEADD(ss, 59,

DATEADD(ms, 997,

DATEADD(MONTH,

DATEDIFF(MONTH,

-1, GETDATE())

- 1, -1))))))) AS FLOAT)

* 1000, 13, 1)) )

AND ( ( ( wo.COMPLETEDTIME != 0 )

AND ( wo.COMPLETEDTIME IS NOT NULL )

)

AND ( wo.COMPLETEDTIME != -1 )

)

AND wo.ISPARENT = 1

) p

Error

net.sf.jasperreports.engine.design.JRValidationException: Report design not valid :

1. Field name missing.

at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:260)

at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144)

at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219)

at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135)

at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:7694)

at com.adventnet.servicedesk.reports.action.ReportRequestHandler.runSQLQueryReport(ReportRequestHandler.java:1595)

at com.adventnet.servicedesk.reports.action.ReportRequestHandler.handleRequest(ReportRequestHandler.java:1890)

at com.adventnet.servicedesk.reports.action.CustomReportHandler.handleRequest(CustomReportHandler.java:176)

at com.adventnet.servicedesk.reports.action.ReportHandler.execute(ReportHandler.java:59)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:116)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at com.adventnet.servicedesk.authentication.NTLMV2CredentialAssociationFilter.doFilter(NTLMV2CredentialAssociationFilter.java:30)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at SSO.http.HttpSecurityService.doFilter(HttpSecurityService.java:894)

at com.adventnet.servicedesk.authentication.NTLMV2Filter.doFilter(NTLMV2Filter.java:139)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)