Skip to Content
0
Former Member
Jan 15, 2008 at 03:55 AM

Query with parameter

24 Views

SELECT OCRD.CardCode AS 'Supplier Code', OCRD.CardName AS 'Supplier Name', OITM.ItemCode AS 'Item Code', OITM.ItemName AS ' Item Description',

OPOR.DocNum AS 'P.O. No', POR1.Quantity AS 'PO Qty', OPOR.DocDueDate AS 'Due Date', OPDN.DocDate AS 'Reciept Date',

PDN1.Quantity AS 'Receipt Qty', PDN1.Quantity - POR1.Quantity AS 'Balance Qty', OPOR.DocTotal AS 'PO Value'

FROM OPDN INNER JOIN

PDN1 ON OPDN.DocEntry = PDN1.DocEntry INNER JOIN

OITM INNER JOIN

POR1 ON OITM.ItemCode = POR1.ItemCode INNER JOIN

OCRD INNER JOIN

OPOR ON OCRD.CardCode = OPOR.CardCode ON POR1.DocEntry = OPOR.DocEntry ON OPDN.CardCode = OCRD.CardCode AND

PDN1.ItemCode = POR1.ItemCode

WHERE (OCRD.CardType = 'S') AND (OPDN.InvntSttus = 'O') and OPOR.DocDueDate between '[% FROM ]' and '[%TO]' ORDER BY OPOR.DocDueDate

I want to pass from date and to date as parameter in the above query.The above query gives error.What correction should ne done ?

Edited by: Dilip Kumbhar on Jan 15, 2008 9:38 AM

Edited by: Dilip Kumbhar on Jan 15, 2008 9:39 AM