2 Replies Latest reply on Apr 28, 2013 11:03 PM by PR R

    Change Filter values based on another value selected in another filter

    PR R

      Hi,

       

      Is there a way through which i could dyanmically change the value of a filter based on another filter? I'm not talking about cascading filters here. the filters here are not related to each other.

       

      Thanks for any help on this in advance.

        • 1. Re: Change Filter values based on another value selected in another filter
          Robin Kennedy

          Could you give an example?

           

          Do you mean to populate the filter options with the contents of a different field in the datasource? This could be accomplished with a calculated field...

           

          Something like

           

          if [Category] = 'Technology' then [Order Priority]

          else [Ship Mode]

          end

          • 2. Re: Change Filter values based on another value selected in another filter
            PR R

            Thanks for your response and the question.

             

            for e.g.

             

            there are the below filters in the report

             

            1. Year (e.g. values All, 2010, 2011, 2012 etc...)

            2. Months (e.g. All, Jan, Feb, Mar... Dec)

            3. Week (e.g. All, wk1, wk2.....wk53)

             

            Now i choose the below values for the filter;

             

            Year = All

            then my Month filter should be defaulted to "All" It should not allow me to choose any months.

             

            And in you response is [Category] a filter?

             

            And when i was exploring this hit against another question. I have a parameter in my report and has the following values

             

            Year, Month, Week, Day .

             

            Can i change this list dynamically based on value selected in one of my quick filters in the report?

             

            Thanks.