Filter over multiple rows
Hello, If I have a table like this ID Code AAAAA X1 AAAAAX2 AAAAA X3 BBBBB X1 BBBBB X2 CCCCC X1 CCCCCX2 CCCCC X3 Is there a way w.out using TSQL to filter the "ID" number which has all three "Code" of X1,X2, X3 associated with it. In the above example I would only want "ID" AAAAA and CCCCC returned. Thanks in Advance
March 7th, 2008 9:33pm

On the properties of the 'table' select filter, and add a data filter =Fields!Code.Value Equals X1 or =Fields!Code.Value Equals X2 or =Fields!Code.Value Equals X3
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2008 11:06pm

Thanks for the reply Phuhn but this does not seem to work since this will also pull ID 'BBBBB' since it has Code 'X1' and 'X2' associated to it I only want the ID that has all three Codes 'X1, X2, X3' associated with it. Any other thoughts? Thanks
March 10th, 2008 7:18pm

you can possible do something like thisa expression =IIF(Fields!myfield.Value = "x1",count(Fields!myfield.Value),0) then you can test the value of 3 and choose to display or not display it. Hammer
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2008 8:37pm

I'm also looking for a way to acomplish this
May 20th, 2011 4:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics