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
- 3303 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 types of Record Groups?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
Explain how can you use the same lov for 2 columns?
What is the difference between Anchoring Object and Enclosing Objects ?
Is it possible to execute a dynamic sql from forms?
How many number of columns a record group can have?
How can a text file be attached to a report while creating in the report writer?
What is a record Group?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Explain types of Block in forms4.0?
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
What are the built_in used to trapping errors in forms 4?
Oracle General 
