5 Replies Latest reply: Jun 24, 2013 1:26 PM by jariola RSS

    How to search a report by drop-down menu

    Jen Hu

      Hello,

            I have a report. When the user first loads the report, i want to show all the columns with value null.  The user can change the report by change the value of a drop-down item col3.

       

      My region source is like:

      select col1, col2, col3 from tablename where col3 is null or col3 = :P2_col3

       

       

      Thanks,

      Jennifer