Interested to Buy Any Domain ? << Click Here >> for more details...
in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........
- 1 Answers
- 4310 Views
- I also Faced
- E-Mail Answers
Answer / tech knit
first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null
and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'
| Is This Answer Correct ? | 0 Yes | 0 No |
How can a cross product be created?
What is an OLE?
What is a library in Forms 4.0?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Can you truncate a table in a procedure in Oracle Forms?
Is it possible to execute a dynamic sql from forms?
When a form is invoked with call_form, Does oracle forms issues a save point?
List the different types of columns in oracle reports.
How to call Report from other Report ?
What is an User_exit?
Is it possible to insert comments into sql statements return in the data model editor?
List the system variables related in Block and Field?
Oracle General 
