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
- 4308 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 |
What is an oracle report?
what is bit map and character mode
Suppose I want to fire block level sequence before form level, then is it possible?
What is a property clause?
What buil-in routines are used to display editor dynamicaly?
From which designation is it preferred to send the output to the printed?
in compatibility in report registration?
What are different types of images?
What are the various methods of performing a calculation in a report ?
Name the different triggers associated with oracle forms having a master-detail relationship.
Can a root window be made modal?
What built-in is used for changing the properties of the window dynamically?
Oracle General 
