HI in report builder am creating paramters.for that i have taken emp table fr

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.

Question Posted / praveen1108

2 Answers
4272 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HI in report builder am creating paramters.for that i have taken emp table from scott user . ..

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

HI in report builder am creating paramters.for that i have taken emp table from scott user . ..

Answer / praveen

sorry raghav it won't work i want dependent dropdown not
report output

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Forms Reports Interview Questions

What is summary column in Oracle Reports ?

5 Answers GE,

What are the built-in used for getting cell values?

1 Answers

What is an oracle report?

0 Answers

How can I sum column wise in Oracle excel report?

1 Answers

What is an User_exit?

2 Answers

What is AppCore and AppCore2 ?

1 Answers

if u want to delete all these detail block etc what will happen in form

0 Answers

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 ?

0 Answers

What are the two ways to incorporate images into a oracle forms application?

1 Answers

List the Types of Items?

1 Answers

Name the different triggers associated with oracle forms having a master-detail relationship.

0 Answers

What is an User Exits ?

1 Answers

For more Oracle Forms Reports Interview Questions Click Here