I'm using Reports 6i.

Example:

I have a report with query
Select * from emp
where deptno = :P_1;

My parameter is based on following query.

Select distinct deptno from emp;


Report runs just fine. Qusetion is when Parameter forms comes up I can select deptno 10,20, or 30, but what I want is this not just deptno 10,20, or 30 come up but it also give me option to select "ALL" so I can also select all the deptno as well.

How can I do that, I'm pretty new o DEV 2000

Thanks in Advance.