0 Replies Latest reply: Sep 20, 2012 9:32 AM by kritichitranshi RSS

    hierarchy in the filters

      Hi

       

      How can I have hierarchy in the two seperate filters for a report.. for eg. company and branch filters are coming from the same column Org_code of Organization table.

      How can I make branch filter dependant on company filter we distinguish the them by the lookup to another column organization type which is having tags like company and branch

       

      My table structure is like:

       

      organization:

      Org_code     organization type  Parent Org

      ABC              Company              -

      CDE              Branch                  ABC

      EFG              Company              -

      HIJ                Branch                  EFG

       

      I want to have a list box to filter company another list box to filter branch which is depandant on the company and by selecting the branch rest of the data would be displayed.

       

      can anyone please help me with this..

       

      Many Thanks

      Kriti