Lookup Filter on rows that match

• S t e f

  SSC Eights!

  Points: 977

  More actions

  January 24, 2013 at 9:30 am

  #288304

  Hi

  I have 2 datasets, one a SQL Server SP and another an XML datasource, I am pulling in the values of the matching clients by using the lookup function in R2, effectively this is giving me a left join, what I actually want is to only display rows that contain matching data from both datasets. Is there a way to do this? I cannot filter based on a dataset that is not part of the tablix.

  Thanks.

  Stef.

• S t e f

  SSC Eights!

  Points: 977

  More actions

  January 24, 2013 at 9:51 am

  #1580615

  Got around this by using a row level filter below:

  =iif( (IsNothing(Lookup(CInt(Fields!id.Value),CInt(Fields!id.Value),Fields!Name.Value, "DataSetName")) = True), True, False)