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
- 3248 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 THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
What use of command line parameter cmd file?
Do user parameters appear in the data modal editor in 2.5?
List the buil-in routine for controlling window during run-time?
all steps of bitmap report?
if u develop report do u ask for anything from u r team leader
What are visual attributes?
What the PAUSE package procedure does ?
what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
If two groups are not linked in the data model editor, What is the hierarchy between them?
Oracle General 
