database design - oracle report builder 6i - sql query code in Data Model -

i'm vijetha, i'm working on reports 6i & new it. have following query.

in front_end, in reports parameter, when user clicks on 'run' button, ask start_date & end_date inputs.

if user gives start_date & end_date or not give input, no matter code should execute. enter code here 1)if user gives start_date & end_date , reports particular given date should displayed. 2)if user not give start_date & end_date,

then reports of dates must displayed.

so have use 2 select statements. are:

1)select * t1 to_char(due_date, 'mmyyyy') between :start_date , :end_date;

2)select * t1;

i want below:

--

if start_date=null & end_date=null, select * t1; else  select * t1 to_char(due_date, 'mmyyyy') between :start_date , :end_date; end if; 

--

but above code not work since sql query statement in data model should coded inside select statement,hence must inside select statement, below:

--

select[ if start_date=null & end_date=null, select * t1; else  select * t1 to_char(due_date, 'mmyyyy') between :start_date , :end_date; end if; ] t1; 

--

---

i tried nvl & decode , not work multiple values.

please me above coding part in query dialog(sql query statement) in data model.

thank you.

your not stored selected value in pl/sql variable.as know need stored selected value in perticular variable.you may use scalar or record type variable stored data.