Does anyone know if the "Custom SQL query Report" function within the Reporting Center of work flow manager can understand derived tables?
My query makes use of a derived table, and even though the syntax checker states all is OK, running the report produces 0 rows. The query functions perfectly outside the front-end which leads me to think it's a system problem.
thanks