Experts
I need to filter both Docdate & Cardname after running the query. But i am not getting the expected results. Can anyone help me in solving this.
Following is the query.
T1.[LineStatus], T0.[CANCELED]
FROM OPOR T0
INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[CANCELED] = 'Y' AND t0.CardName >= '[%0]' AND T0.DocDate BETWEEN [%1] and [%2]
group by T1.U_PROJECT,T0.U_PRNO,T0.[DocNum],T0.[DocDate],T0.[CardName],T0.[DocTotal],T0.Comments,T1.[LineStatus], T0.[CANCELED]
regards
Karthik