NOT In filter on Tablix in SSRS

  • 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 ?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply