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
- 4260 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we expand Parameter Form Canvas on Reports 6i?
what is tripstop report?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
In what sequence do triggers get fired by oracle forms?
Explain the various types of oracle report?
What do you understand by lov?
how do u compile a form i.e .fmb file in Unix or in dos
Explain how can you use the same lov for 2 columns?
i am writing a query select EmpNo from Emp how can i call in after parameter form
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
How can we generate report output in excel format?
what is oracle forms?
how do u place it in required folder
What are the various configuration files that are used by oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
