Hi,
I've been developing/experimenting with a lot of report templates (not the SQL directly though). I'll try to describe it as best I can.
When you do a max condition, normally you would get just a single result. If you want to get a max for each of something, then that something has to be defined in the main query, and the subselect has a criteria that goes back to the main query.
So basically in your subquery, you would add a criteria that the view = the view of the WTpart from the main query. That way, you should get a result for the max of each view of each WTPart.
