5 Replies Latest reply: Jun 24, 2013 1:48 PM by Jen Hu RSS

    How to search a report by drop-down menu

    Jen Hu


            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