Report Builder 3.0 Exclusion Query based on Parameter and Field Values

  • Hi,

    I am creating a report which has a Full and Partial Parameter. If the Partial parameter is selected I want to exclude any entry in the SubmissionID column with a value of 47 and 51 from the report

    I can get it to work using just 1 of the values but not using the 2

    This is the expression that works for me using only 1 value and I put it the query window of the dataset, the use if 'Niamh' is just to have an else value as it wouldn't work otherwise. When the report is run using this it excludes all entries with a value of 47 which is what I want except I also want to exclude 51 values also:

    Where

    (Reporting.SUBMISSIONS.SubmissionTypeID <> case when @FullorPartial= 2

    then 47 else 'Niamh' end)

    I have also tried using an IIF on the Visibility option in the Group Properties of the Row Group which didn't work either.

    =IIF((Parameters!FullorPartial=2) AND (SubmissionID IN (51, 47), True, False))

    Any help would be very much appreciated as I have tried all number of variations without success

    Thanks

    Niamh

  • Any help would be much appreciated

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

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