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........



in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in th..

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

Post New Answer

More Oracle Forms Reports Interview Questions

What is the "LOV of Validation" Property of an item? What is the use of it?

1 Answers  


in before report trigger SRW.user_exit(FND_Userinit) what will do

3 Answers  


What are the two phases of block coordination?

1 Answers  


What are the built-in used for getting cell values?

1 Answers  


What package procedure used for invoke sql plus from sql forms ?

1 Answers  


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

0 Answers   Zensar,


Identify package function from the following ?

1 Answers  


What are User Exits and what are different types of User Exits in Oracle Apps ?

2 Answers  


Any attempt to navigate programatically to disabled form in a call_form stack is allowed?

1 Answers  


What is the advantage of the library?

2 Answers  


What are visual attributes?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)