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...

We are running 6.0.0.22 and have rescanned our assets but are still experiencing the same problem as the OP in a previous post on this topic (http://www.lansweeper.com/Forum/yaf_postst12838_Ip-Range-Location-problem.aspx#post46037) – any suggestions?...