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
- 4266 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 is an User Exits ?
What are the different file extensions that are created by oracle reports?
How many types of trigger can be used in a table at a time ?
What are the default extension of the files created by library module?
How can a button be used in a report to give a drill down facility?
HI GURUS, WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT DEVELOPMENT.
How can we expand Parameter Form Canvas on Reports 6i?
Where is the external query executed at the client or the server?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
can u call procedure or function is sq l query in reports
what is integrity n how many integrity rules r there?
What are the various configuration files that are used by oracle forms?
Oracle General 
