NOT In filter on Tablix in SSRS

• itwhiz

  Mr or Mrs. 500

  Points: 531

  More actions

  October 23, 2013 at 5:49 am

  #299495

  I've got to produce a report that has 2 tables (tablix) on it.

  The first is grouped by chosen Area's (parameter) with a Region

  The Second is Group by a specific Region and 'Other'

  Such as

  Table 1

  Region 1

  On-Time Today 1-5 Days > 5days

  Area 1 5 0 1 1

  Area 2 0 1 2 6

  Area 3 6 0 1 10

  11 1 4 17

  Table 2

  On-Time Today 1-5 Days > 5days

  Region 2 5 0 1 1

  Others 0 1 2 6

  5 1 3 7

  So the first table, Table 1, has a filter on it to only select the records that are for Region 1 and are in the paramerter list (area1,area2,area3)

  Now my problem is when appliying a filter to table 2 I want to select all records NOT in the parameter list (area1,area2,area3), but there is only the 'In' operaor on the slectable list.

  Any ideas on how to do this ?

• David Burrows

  SSC Guru

  Points: 65143

  More actions

  October 23, 2013 at 7:06 am

  #1660908

  Define an InStr expression in the filter to return an Integer and check for zero value.

  e.g.

  =InStr(Join(Parameters!ReportParameter1.Value,","),Fields!Area.Value)

  Far away is close at hand in the images of elsewhere.
  Anon.