Index: trunk/grails-app/services/InventoryReportService.groovy
===================================================================
--- trunk/grails-app/services/InventoryReportService.groovy	(revision 562)
+++ trunk/grails-app/services/InventoryReportService.groovy	(revision 564)
@@ -152,6 +152,9 @@
                                         order by inventoryStore.name, inventoryLocation.name"
 
-        result.query = "select  distinct inventoryItem " + result.query
+        // MSSQL will not do distinct here, for some reason it tries to compare the image data type!
+        result.query = "select inventoryItem " + result.query
         result.inventoryItemList = InventoryItem.executeQuery(result.query, namedParams, paginateParams)
+
+        result.inventoryItemList.unique()
 
         // Success.