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
- 4369 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 |
Which parameter can be used to set read level consistency across multiple queries?
Can a property clause itself be based on a property clause?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What does an on-clear-block Trigger fire?
What is a record Group?
What is the built-in used for showing lov at runtime?
What is a Trigger ?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
What is the significance of PAGE 0 in forms 3.0 ?
What is user exit.?
2 Answers IBM, Synergy, Zensar,
what is latest version in reports
How can you format a character field in a report Layout editor ?
Oracle General 
