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
4481 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 an User_exit?

2 Answers

What are the two panes that Appear in the design time pl/sql ?

1 Answers

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...

0 Answers IBM,

What is a Package Procedure ?

1 Answers

What is the difference between boiler plat images and image items?

1 Answers

i am writing a query select EmpNo from Emp how can i call in after parameter form

0 Answers

how can u store a picture file in oracle database? explain the path/command?

1 Answers GE, Satyam,

How to create Drill down report?

0 Answers ABB, ESS, Infosys,

What is the difference between bind and lexical parameter?