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
- 4429 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 are the different objects that you cannot copy or reference in object groups?
Which of the two views should objects according to possession?
What are the built-ins that are used for setting the LOV properties at runtime?
what is integrity n how many integrity rules r there?
What is an LOV?
What is the difference between BPA AND Contract What are documents and test cases u followed
What are the built -ins used for Modifying a group's structure?
How to call a report from Forms?
Where do u define the select statement of the parameter? is it followed by the & variable ?
What is the maximum size of a form ?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What are the types of visual attribute settings?
Oracle General 
