Home Forums Reporting Services SSRS 2012 Parameters having 'Allow multiple values' with Y and N values not producing correct result in table RE: Parameters having 'Allow multiple values' with Y and N values not producing correct result in table

  • November 2, 2015 at 3:49 pm

    #1837232

    Yes, it should select rows from CompanyShortName, ContractCountIndicator which has Y and N multi selections and AssignmentCountIndicator which has Y and N multi selections.

    I have attached a screenshot of what it looks like in front end and also the sample data source.

    Example:

    1) Lets say, I select 'DDD' and FFF from 1st filter "Company Name".

    - Row 5 should display in the table only when my selection is Y in ContractCnt and N in AssignmentCnt and Row 7 should not display in the table and vice-versa.

    2) If BBB and FFF are selected.

    - Row 3 should display in the table only when my selection is Y in ContractCnt and Y in AssignmentCnt and Row 7 should not display in the table.