Dear Forum,
i had this query, but i need to have the result that the report only produce with some percentage variance and more, less percentage no need to display.. and the result sort by variance % (bigger to lesser).
the variable percentage above put on query (without asking option)
SELECT T0.DocEntry, T1.CardCode, T1.CardName, T1.DocDate, T0.ItemCode, T0.Dscription, T0.PriceBefDi, T2.LastPurPrc, (T0.PriceBefDi - T2.LastPurPrc) AS Variance, ((T0.PriceBefDi - T2.LastPurPrc)/T0.PriceBefDi) AS 'Variance%', T3.SlpName FROM dbo.POR1 T0 INNER JOIN dbo.OPOR T1 ON T0.DocEntry = T1.DocEntry INNER JOIN dbo.OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN dbo.OSLP T3 ON T0.SlpCode = T3.SlpCode
WHERE Month(T1.docdate) = MONTH(GETDATE()) and Year(T1.docdate) = YEAR(GETDATE())