9 Replies Latest reply: Jul 17, 2013 3:37 PM by ScriptMan RSS

    Multi-Criteria Filter - Using Multiple Drop downs

    ScriptMan

      I have dashboard application feeding from the same results set.  It works fine with a one parameter filter.  However, I'm trying to allow the user to make selects from more that one object (in this case, drop down boxes).  How can I use multiple boxes to do this?  Here is the code I've developed thus far which is not working:

       

      //******************* REGION FILTER ********************
      var SelectionRegion;
      SelectionRegion=drop_YearSelect.Item(drop_Region.SelectedIndex);

      //New Accounts

      ActiveDocument.Sections["Results1"].Limits["REGION"].SelectedValues.RemoveAll()
      ActiveDocument.Sections["Results1"].Limits["REGION"].CustomValues.RemoveAll()
      ActiveDocument.Sections["Results1"].Limits["REGION"].CustomValues.Add(SelectionRegion)
      ActiveDocument.Sections["Results1"].Limits["REGION"].SelectedValues.Add(SelectionRegion)

      //********************* YEAR FILTER ***********************
      var Selection;

      Selection=drop_YearSelect.Item(drop_YearSelect.SelectedIndex);

      //Pivot One

      ActiveDocument.Sections["Results1"].Limits["Ftr Creat Dt Year"].CustomValues.Add(Selection)
      ActiveDocument.Sections["Results1"].Limits["Ftr Creat Dt Year"].SelectedValues.Add(Selection)

      //Pivot Two

      ActiveDocument.Sections["Results2"].Limits["FtrCloseDtYear"].CustomValues.Add(Selection)
      ActiveDocument.Sections["Results2"].Limits["FtrCloseDtYear"].SelectedValues.Add(Selection)

      //Pivot Three

      ActiveDocument.Sections["Results3"].Limits["FtrCloseDtYear"].CustomValues.Add(Selection)
      ActiveDocument.Sections["Results3"].Limits["FtrCloseDtYear"].SelectedValues.Add(Selection)