Home » Developer & Programmer » Reports & Discoverer » Exect Fetch
Exect Fetch [message #309954] Sun, 30 March 2008 10:08 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
How to fetch the extact query in reports....

----------------------------------------- -------- ------------------
ID_NO NOT NULL VARCHAR2(15)
USERNAME NOT NULL VARCHAR2(30)
MOBILE# NUMBER(15)
TEL# NUMBER(10)
EXT# NUMBER(6)
EMAIL1 VARCHAR2(50)
EMAIL2 VARCHAR2(50)
DEPT VARCHAR2(20)
EMP_PIC LONG RAW
MOBILE#2 NUMBER(15)
HOME_TEL NUMBER(15)
JOB_TITLE VARCHAR2(30)
LOCATION VARCHAR2(20)

i wanna to fetch the record through ID # in report how to fetch i try to user parameter but it shows all items,
i wanna to fetch the exact record by ID no support if user enter the ID no it will fetch the exact record. how to fetch please help

Regards
Re: Exect Fetch [message #309969 is a reply to message #309954] Sun, 30 March 2008 15:51 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, you should use a parameter.

If you did that but got all records instead of just one, then you did something wrong. Without knowing the exact query you used and possible additional information (parameter datatype, sample data etc.), it is impossible to guess what is the reason of a failure.
Re: Exect Fetch [message #310192 is a reply to message #309954] Mon, 31 March 2008 09:19 Go to previous message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Thanks little its solved.......
Previous Topic: Need alternative method to export data from Oracle To Excel
Next Topic: Master Details Report
Goto Forum:
  


Current Time: Fri Dec 09 19:48:50 CST 2016

Total time taken to generate the page: 0.15526 seconds