OraFAQ Forum: Reports & Discoverer » how to use param's in reports

Home » Developer & Programmer » Reports & Discoverer » how to use param's in reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use param's in reports [message #618033]

Mon, 07 July 2014 00:22

mist598
Messages: 1195
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

Report message to a moderator

Re: how to use param's in reports [message #618035 is a reply to message #618033]

Mon, 07 July 2014 00:38

azamkhan
Messages: 557
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.

Report message to a moderator

Re: how to use param's in reports [message #618051 is a reply to message #618035]

Mon, 07 July 2014 05:53

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally, parameters should be preceded with a colon (:), such as

where deptno = :p_deptno

Report message to a moderator

Previous Topic:	0 instead of null column based on 2-queries (CM merged 2)
Next Topic:	How to run sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:42:52 CST 2024