Passing parameter in Reports

[gk2468]

How to Pass values between userparameter
Ex. Two Userparameter created Dept_no,Empno

If Dept_no valuse entered 10 then Empno should display of dept_no=10 employee numbers

[aph]

1. Create parameter dept_no
2. write below query
SELECT ENAME,
DEPTNO,
HIRE_DATE,
SAL
FROM EMP
WHERE EMPNO = :dept_no

3. Run report and enter any dept number you want.

Thanks.