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
- 4365 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 |
If a break order is set on a column would it effect columns which are under the column?
Give the sequence of execution of the various report triggers?
How do you reference a Parameter?
Can a formula column be obtained through a select statement?
How can you execute the user defined triggers in forms 3.0 ?
what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)
What are the built -ins used for Modifying a group's structure?
what is the difference between call_form, new_form and open_form?
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
what is integrity n how many integrity rules r there?
What are the type of User Exits ?
Can a sigle canvas be used by different blocks ?
Oracle General 
