Gabe Lebron
asked on
SSRS and & or filters
I have a questions on Filters I need soso.status ='open' and SOSOline.Status ='open' that works good but i need to add the IMItems also but now turns the closed as well what am am I during wrong.
SELECT SNSalesRep.Name, SOSO.SONumber, SOSO.ShipToName, SOSO.Status, SOSOLine.Status AS Expr1, SOSO.CustomerPO, SOSO.ContactFirstName,
SOSO.ContactLastName, SOSO.WrittenBy, SOSOLine.SOLineNumber, SOSOLine.Item, SOSOLine.Quantity, SOSOLine.DateOrdered,
SOSOLine.DateRequired, SOSOLine.UsePriceOverride, SOSOLine.UnitPriceOverride, SOSOLine.UnitPriceCalculated, SOSOLine.QuantityShipped,
ARCustomer.Name AS Expr2, SOSO.ContactPhone, SOSO.ContactEmail, IMItem.SPC
FROM SOSO AS SOSO INNER JOIN
ARCustomerShipTo AS ARCustomerShipTo ON SOSO.CustomerShipTo = ARCustomerShipTo.CustomerShipTo INNER JOIN
SOSOLine AS SOSOLine ON SOSO.SONumber = SOSOLine.SONumber INNER JOIN
ARCustomer AS ARCustomer ON ARCustomerShipTo.Customer = ARCustomer.Customer INNER JOIN
SOSOLineRep AS SOSOLineRep ON SOSOLine.SONumber = SOSOLineRep.SONumber AND
SOSOLine.SOLineNumber = SOSOLineRep.SOLineNumber INNER JOIN
SNSalesRep AS SNSalesRep ON SOSOLineRep.SalesRep = SNSalesRep.SalesRep INNER JOIN
IMItem ON SOSOLine.Item = IMItem.Item
WHERE (SOSO.Status = 'OPEN') AND (SOSOLine.Status = 'OPEN') AND (IMItem.SPC = 'JWGAS') OR
(IMItem.SPC = 'JWCG') OR
(IMItem.SPC = 'JWOR') OR
(IMItem.SPC = 'TORAC')
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The OR condition that brings the closed. Which means even if status values is closed they could have (JWCG, JWOR, TORAC) on its spc column. Are you trying to do some thing like this one?
(SOSO.Status = 'OPEN') AND (SOSOLine.Status = 'OPEN')
AND
(
(IMItem.SPC = 'JWGAS')
OR (IMItem.SPC = 'JWCG')
OR (IMItem.SPC = 'JWOR')
OR (IMItem.SPC = 'TORAC')
)
ASKER
Worked Perfect thank you
WHERE (SOSO.Status = 'OPEN') AND (SOSOLine.Status = 'OPEN') AND (IMItem.SPC IN ('JWGAS', 'JWCG', 'JWOR', 'TORAC'))