locked
Enable or disable filter RRS feed

  • Question

  • I have a table that contains a column I want to put a filter on. Lets say the column contains two possible values, "Enabled" or "Disabled". What I want to do is to be able to show "Enabled" rows only, "Disabled" rows only or both.
    Is there a way to do that ? I create a parameter and I populate the available values from a query. I then create a filter that limits the column value to that of the parameter. The problem with this approach is that I can not display both "Enabled" and "Disabled" rows at the same time.

    Any ideas ?
    Wednesday, September 17, 2008 8:10 PM

Answers

  • Mark the report parameter as a multi-value parameter in Report Designer.

    Friday, September 19, 2008 2:51 AM

All replies

  • Hi

     

    You can try using WHERE Column In (@Status)

    Where status parameter will be popluated with valued from query

     

    or you can use Dataset filter tab to filter the records as

     

    =Fields!Column.Value IN =Parameters!Status.Value

     

    Thanks

     

    Thursday, September 18, 2008 7:43 AM
    Answerer
  • Mark the report parameter as a multi-value parameter in Report Designer.

    Friday, September 19, 2008 2:51 AM