OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » parameter report

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

parameter report [message #258162]

Fri, 10 August 2007 07:26

ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad

Junior Member

hi
I have one report.the query in this report is

select * from emp where empno=:A

If i enter value of A it will give information of employee related to the value of A.

my problem is if I didn't enter the value of A,it should give all the employees information.

can any one help in this

Report message to a moderator

Re: parameter report [message #258228 is a reply to message #258162]

Fri, 10 August 2007 10:51

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Please format your post first.

Your query should be

select * from emp where empno=nvl(:A,empno)

Cheers
Sanka

Report message to a moderator

Re: parameter report [message #258332 is a reply to message #258228]

Sat, 11 August 2007 02:19

ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad

Junior Member

Thanks a lot

Report message to a moderator

Previous Topic:	when fetching data from database its take too much time and display in reports,?
Next Topic:	please give me the suggession what is the this internal Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:46:44 CST 2024