DataSource1 52473fb4-0bff-4dfb-a251-130e2b800580 None SKU System.String sales System.Decimal onhand System.Decimal DataSource1 IF NOT object_id('tempdb..#Stock') IS NULL DROP TABLE #Stock CREATE TABLE #Stock ( SKU VARCHAR(10) NOT NULL, sales DECIMAL(12,0), onhand DECIMAL(12,0) ) INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU001', 100, 2000); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU002', 200, 1900); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU003', 300, 1800); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU004', 400, 1700); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU005', 500, 1600); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU006', 600, 1500); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU007', 700, 1400); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU008', 800, 1300); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU009', 900, 1200); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU010', 1000, 1100); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU011', 1100, 1000); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU012', 1200, 900); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU013', 1300, 800); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU014', 1400, 700); INSERT INTO #Stock (SKU, sales, onhand) VALUES ('SKU015', 1500, 600); SELECT * FROM #Stock WHERE (@Condition = 1 AND sales > @Value) OR (@Condition = 2 AND sales < @Value) OR (@Condition = 3 AND onhand > @Value) OR (@Condition = 4 AND onhand < @Value) OR (@Condition = 5 ) =Parameters!Condition.Value true =Parameters!Value.Value true true 1in 1in 1in 0.25in true true SKU CornflowerBlue 2pt 2pt 2pt 2pt true true Sales CornflowerBlue 2pt 2pt 2pt 2pt true true On-Hand CornflowerBlue 2pt 2pt 2pt 2pt 0.25in true true =Fields!SKU.Value 2pt 2pt 2pt 2pt true true =Fields!sales.Value 2pt 2pt 2pt 2pt true true =Fields!onhand.Value 2pt 2pt 2pt 2pt After DataSet1 0.00708in 0.00708in 0.5in 3in 0.50708in