A report created using Microsoft Visual Studio 2005 is working fine in Studio, and RDL file uploads into RM successfully, but when running the report the following error is received:
"An error has occurred during report processing.
Query execution failed for data set 'RMStage'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
SumTotal support is telling us that the report is using a SQL syntax is not supported by the RM. They said that we need to use CTE syntax (Common Table Expression) instead of Derived Tables.
This is the simple query that I am using for the report.
SELECT SUM(Activities.EstDur) AS [Duration in Seconds], ActivityType.ActLabel_Name AS [Activity Type], ROUND(SUM(Activities.EstDur) / 3600, 0) AS [Training Hours]
FROM dbo.ActLabel AS ActivityType RIGHT OUTER JOIN
dbo.TBL_TMX_Attempt AS Attempts LEFT OUTER JOIN
dbo.tblEmp ON Attempts.EmpFK = dbo.tblEmp.Emp_PK LEFT OUTER JOIN
dbo.TBL_TMX_Activity AS Activities ON Attempts.ActivityFK = Activities.Activity_PK ON ActivityType.ActLabel_PK = Activities.ActivityLabelFK
WHERE (Attempts.EndDt > CONVERT(DATETIME, '2008-12-31 00:00:00', 102))
GROUP BY ActivityType.ActLabel_Name, ActivityType.ActLabel_PK
HAVING (ActivityType.ActLabel_PK = - 3) OR
(ActivityType.ActLabel_PK = - 7)
Would someone please help me to find what is wrong with this query?
Thanks,
Oscar E Posada.
__._,_.___
Reply to sender |
Reply to group |
Reply via web post |
Start a New Topic
Recent Activity:
Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use
.
__,_._,___