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
- 3406 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 different types of modules available in oracle form?
Give built-in routine related to a record groups?
how to send file attachment from oracle forms
What is the use of Validation triggers in Reports?
What is the difference between system.current_field and system.cursor_field ?
What are the three types of user exits available ?
What are the different types of key triggers ?
I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad
What are the default extentions of the files created by menu module?
Can you change the color of the push button in design time?
Where we can use the placeholder columns?
What is forms_DDL?
Oracle General 
