I would like to get more information. I created a Total In Stock Inventory Report and its coming out fine. But the only things is not showing the record if the QTY is 0. Shall I write a condition statement with in the QTY field as IIF statement or shall I put on the Script itself. Here is the script on my data tab. I am using only 4 talbes i.e. PRTAREA,PRTLOC,PRTCAT,PRTLTSK. From PRTAREA the only field I am getting is STKAREA, From PRTLOC table I am getting only PRTLOC field, From PRTCAT table I am getting only PRTNO,PRTDESC,BILLCST fields. From PRTLTSK is the QTY field. Let me know your comments. Thanks!


SELECT INVENTORY.PRTAREA.STKAREA, INVENTORY.PRTLOC.STKLOC, INVENTORY.PRTCAT.PRTNO, INVENTORY.PRTCAT.PRTDESC,
INVENTORY.PRTLOT.UNITCST, INVENTORY.PRTLOT.QTYUSED, INVENTORY.PRTLOT.QTYRECD, INVENTORY.PRTLOT.RECDDTTM,
INVENTORY.PRTLTSK.QTY, INVENTORY.PRTCAT.BILLCST
FROM INVENTORY.PRTLOC INNER JOIN
INVENTORY.PRTSTK ON INVENTORY.PRTLOC.STKLOCKEY = INVENTORY.PRTSTK.STKLOCKEY INNER JOIN
INVENTORY.PRTCAT ON INVENTORY.PRTSTK.PRTKEY = INVENTORY.PRTCAT.PRTKEY INNER JOIN
INVENTORY.PRTLOT ON INVENTORY.PRTCAT.PRTKEY = INVENTORY.PRTLOT.PRTKEY INNER JOIN
INVENTORY.PRTAREA ON INVENTORY.PRTLOC.STKAREAKEY = INVENTORY.PRTAREA.STKAREAKEY AND
INVENTORY.PRTSTK.STKAREAKEY = INVENTORY.PRTAREA.STKAREAKEY INNER JOIN
INVENTORY.PRTLTSK ON INVENTORY.PRTSTK.STKKEY = INVENTORY.PRTLTSK.STKKEY AND
INVENTORY.PRTLOT.STKLOTKEY = INVENTORY.PRTLTSK.STKLOTKEY
GROUP BY INVENTORY.PRTAREA.STKAREA, INVENTORY.PRTCAT.PRTNO, INVENTORY.PRTCAT.PRTDESC, INVENTORY.PRTLOT.UNITCST,
INVENTORY.PRTLOT.QTYUSED, INVENTORY.PRTLOT.QTYRECD, INVENTORY.PRTLOT.RECDDTTM, INVENTORY.PRTLOC.STKLOC,
INVENTORY.PRTLTSK.QTY, INVENTORY.PRTCAT.BILLCST
HAVING (INVENTORY.PRTAREA.STKAREA = @STKAREA)