I'm trying to create a dataview based on the SLPlanningDetails which appears to be a view rather than a typical table. So when I'm trying to pull only unique records in the Dataview Filter it is giving me an error that an aggregate cannot be used in a WHERE clause. I'm not using any aggregate, just date and string fields but I believe its just not working since it is a view, that is the only difference I can figure out from other dataviews I've created and done this same thing. So my question is - does anyone know any tricks to pulling only unique records into a dataview. In my current dataview it is pulling each record 3 times, however when I open the Planning Details form, it only shows each line 1 time.
