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
- 4366 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
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
a text item is there what r the different types of triggers associated with it
What is the difference between BPA AND Contract What are documents and test cases u followed
How can we expand Parameter Form Canvas on Reports 6i?
hiding item in report how like that properly,thats manually but at runtime i want to do
how do u place it in required folder
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
from where do u receive the information to develop report
What do we mean by record group in oracle forms?
Explain master-detail relationship with some examples.
What do you understand by oracle forms and why are they required?
Name the different triggers associated with oracle forms having a master-detail relationship.
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What do you understand by lov?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
