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
Printable View
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
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.