OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » search on report

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

search on report [message #216527]

Mon, 29 January 2007 03:55

amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi

Member

hello Sir,
Is this possible to give search button on Oracle reports.

Report message to a moderator

Re: search on report [message #216540 is a reply to message #216527]

Mon, 29 January 2007 05:37

amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi

Member

plz help me. My prob is:-

Suppose i run a report which give me details of employee salary. now user want that there should be a button. by clicking on that button, i can search for a employee by giving his/her name in a text field. is this possible? Plz tell me.
thanks

Report message to a moderator

Re: search on report [message #216541 is a reply to message #216540]

Mon, 29 January 2007 05:40

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

Senior Member
Account Moderator

You could create a user parameter and use it in the WHERE clause of the query.

Report message to a moderator

Re: search on report [message #216544 is a reply to message #216541]

Mon, 29 January 2007 05:52

amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi

Member

thanks sir, but is it possible to search on report.

Report message to a moderator

Re: search on report [message #216552 is a reply to message #216544]

Mon, 29 January 2007 06:24

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

Senior Member
Account Moderator

I guess that you'd like to add a text field to your report and a "Search" button next to it, so that it would "emulate" search facility used in, for example, Opera web browser to "Find (something) in page".

If so, I'm sorry - I never tried to do that. You might, however, display the report results as a PDF document and use Acrobat Reader's search facility.

Report message to a moderator