Create a simple Easy SQL Query
You can generate an Easy SQL query like this...
select tdilc501.item, tdilc501.cwar, tdilc501.loca,
tdilc501.clot, tdilc501.qstk, tdilc501.cstk,
from tdilc501, tiitm001
where tdilc501.item refers to tiitm001
The output of this can be taken to excel and then it can be analyzed by Item, Warehouse, etc. Alternatively, you can also create a print session based on the tdilc501 & tiitm001 tables.
I have created several reports on the cycle counts sorted by Warehouse, by Location, by Item, by Item Group, by Item Type, etc.