I have 2 lists.
Locations table has fields Location and ID
Inventory table has fields Location (look up from Locations), Date, Inventory, etc.
I need to create report which locations DID NOT submit inventory to the end of the month.
Is it possible to do in SharePoint Designer and how?
I can link two lists in one DataView but do not know how to do Left join there.