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........
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 "LOV of Validation" Property of an item? What is the use of it?
in before report trigger SRW.user_exit(FND_Userinit) what will do
What are the two phases of block coordination?
What are the built-in used for getting cell values?
What package procedure used for invoke sql plus from sql forms ?
What is user exit.?
2 Answers IBM, Synergy, Zensar,
What is the difference between BPA AND Contract What are documents and test cases u followed
Identify package function from the following ?
What are User Exits and what are different types of User Exits in Oracle Apps ?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
What is the advantage of the library?
What are visual attributes?