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.
- 2 Answers
- 3446 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghav
first create a sql query in the data model like below
select empno from emp no where deptno=:p_deptno.run the
report
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the built-ins that are used for setting the LOV properties at runtime?
what is integrity n how many integrity rules r there?
What is a library in Forms 4.0?
Commited block sometimes refer to a BASE TABLE ? True or False.
What the PAUSE package procedure does ?
running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?
What is new_form built-in?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
How you define procure to pay?
What is a Layout Editor?
Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com
explain about content canvas views?
Oracle General 
