Home » Developer & Programmer » Reports & Discoverer » search on report
search on report [message #216527] Mon, 29 January 2007 03:55 Go to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
hello Sir,
Is this possible to give search button on Oracle reports.
Re: search on report [message #216540 is a reply to message #216527] Mon, 29 January 2007 05:37 Go to previous messageGo to next message
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
Re: search on report [message #216541 is a reply to message #216540] Mon, 29 January 2007 05:40 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: search on report [message #216544 is a reply to message #216541] Mon, 29 January 2007 05:52 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
thanks sir, but is it possible to search on report.
Re: search on report [message #216552 is a reply to message #216544] Mon, 29 January 2007 06:24 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: search on report [message #216557 is a reply to message #216552] Mon, 29 January 2007 06:44 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
thanks for ur reply
Re: search on report [message #216559 is a reply to message #216557] Mon, 29 January 2007 07:13 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome, but I'm not sure you found my words helpful.
Previous Topic: Output Problem
Next Topic: A tricky little one (re: discoverer)
Goto Forum:
  


Current Time: Sat Dec 03 03:39:39 CST 2016

Total time taken to generate the page: 0.18756 seconds