Home » Developer & Programmer » Reports & Discoverer » parameter report
parameter report [message #258162] Fri, 10 August 2007 07:26 Go to next message
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


icon14.gif  Re: parameter report [message #258228 is a reply to message #258162] Fri, 10 August 2007 10:51 Go to previous messageGo to next message
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
Re: parameter report [message #258332 is a reply to message #258228] Sat, 11 August 2007 02:19 Go to previous message
ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad
Junior Member
Thanks a lot
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:
  


Current Time: Thu Dec 05 01:11:24 CST 2024