Post reply

Dynamic filter

  • September 1, 2008 at 7:31 am

    #192213

    Does anyone know if it is possible to apply a filter to a dataset or table based on the value of a report parameter? So, if FilterParam = true -> apply filter otherwise no filter.

    Thanks

    Ben

  • September 2, 2008 at 12:08 am

    #865843

    If u Right click the table and go to filters tab , there you can filter by paramters!

    just check it out

    Thanks

  • September 2, 2008 at 1:06 am

    #865853

    Hi

    I don't want the parameter to act as the value in the filter criteria I want to use it to determine whether to perform the filter or not. I actually want to use it to give the user the option of viewing negative numbers in a particular field or not. The solution I have used is to put the following expressions in the filter dialog:

    Field: Iif(Parameters!ShowAll = "Yes", 1, Fields!MyField)

    Operator: >=

    Value: =0

    So if the user wants to see everything ShowAll = "Yes" and the filter expression is 1 >= 0 which will show all data otherwise Fields!MyField >= 0 removes negative numbers.

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

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