The report design interface SQL parser seems incapable of handling correlated subqueries or RANK ( ) OVER ( [ PARTITION BY partition_by_column ] ORDER BY order_by_column [ASC|DESC] ) = 1 syntax to allow the retrieval of the top row in a related table for each row in the main query. Shouldn't these both work here? Currently all I get is unexpected token reports for what is perfectly valid T-SQL.
