Home Forums Reporting Services Reporting Services Can I allow a user to select nothing a multi-valued parm? RE: Can I allow a user to select nothing a multi-valued parm?

  • October 20, 2016 at 1:16 am

    #1907570

    That means you don't filter the value of ID1

    and only filter on ID2,3,4,5,6

    Something like

    where (@IgnoreID1='Y' or @ID1 in (......))

    and (@IgnoreID2='Y' or @ID2 in (......))

    ...