I'm a little embarrassed to ask this question as it seems so elementary. However; maybe there are others who have experienced a similar situation, which I have run into occasionally.
Let's suppose that I have a select list item (P1_YEAR) for "year" which controls the rows which are displayed in an interactive report through its where clause, and the select list P1_YEAR has three values (2014,2013,2012). There is a fourth value of NULL which has a "Null Display Value", of "All Years". The user can select "All Years" and the logic is setup to display all records for (2014,2013,2012).
The problem is that I want the deafult to be the current year or 2014, so I set the default value of P1_YEAR to be TO_CHAR(SYSDATE,'YYYY'). The problem with this approach is that it makes NULL/"All Years" never work, because the default of TO_CHAR(SYSDATE,'YYYY') for P1_YEAR always kicks in whenever NULL is selected.
I'm hopeful that there is a way to default to the current year P1_YEAR, without dummying up all of my NULL year records (i.e., aggregations I created). Has anyone else figured out a work around for this?