Home » Developer & Programmer » Reports & Discoverer » how to use param's in reports
how to use param's in reports [message #618033] Mon, 07 July 2014 00:22 Go to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

how to use 2 parameters in the reports?Please suggest.

SELECT ename, 
       (SELECT Max(hiredate) 
        FROM   emp 
        WHERE  empno = p_empno)next_date 
FROM   emp 
WHERE  deptno =p_deptno--10 


Thanks
Re: how to use param's in reports [message #618035 is a reply to message #618033] Mon, 07 July 2014 00:38 Go to previous messageGo to next message
azamkhan
Messages: 556
Registered: August 2005
Senior Member
I think you want to replace "p_empno" and p_deptno" right? If that is so all you have to do is create to parameter in the report navigator under the parameter node. And replace "p_empno" and "p_dept_no" with parameter names.
Re: how to use param's in reports [message #618051 is a reply to message #618035] Mon, 07 July 2014 05:53 Go to previous message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Additionally, parameters should be preceded with a colon (:), such as
where deptno = :p_deptno
Previous Topic: 0 instead of null column based on 2-queries (CM merged 2)
Next Topic: How to run sql query
Goto Forum:
  


Current Time: Sat Nov 16 17:36:27 CST 2019