I get the following message when trying to execute a crystal report after setting the SQL compatibility mode from SQL2000 to SQL2005, any help would greatly be appreciated.
Thanks
JW

After doing some additional research, I found the underlying tsql stored procedure generates the following error:
Msg 164, Level 15, State 1, Procedure SP_X_Performance_Data, Line 437
Each GROUP BY expression must contain at least one column that is not an outer reference.
---------------------------------------------------------

Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception
javax.servlet.ServletException:
No error.
     org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
     org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
     org.apache.jsp.jsifbltest.report_jsp._jspService(report_jsp.java:391)
     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)



root cause
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException:
No error.---- Error code:-2147483648 Error code name:failed
     com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
     com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
     com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
     com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.do(Unknown Source)
     com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.verifyDatabase(Unknown Source)
     org.apache.jsp.jsifbltest.report_jsp._jspService(report_jsp.java:305)
     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)



Edited by Jim Wile - 16 Jul 2015 at 8:03am