Passing parameter in Reports
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Passing parameter in Reports

  1. #1
    Join Date
    Oct 2004
    Posts
    7

    Post Passing parameter in Reports

    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

  2. #2
    Join Date
    Jul 2001
    Posts
    334
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width