Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5065 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh a.
Create a report in drill down manner.
1) create a report only for deptno
then go onto report layout editor
create a push button
write code on push button to call another report base on
deptno. (please see srw.run_report )
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudipta santra
Yes Dinesh, U r perfect but one question is that is there
any necessity to call another report? If I pass the
parameter from a form of the dept no from user selection
then that parameter can be binded up in query data model
then the report will populate the all empnums of that user
chosen particular dept no.
If am I not wrong, then is it not a easiest method?
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the significance of PAGE 0 in forms 3.0 ?
What is the difference between flex mode and confined mode?
What are the type of User Exits ?
how to call forms in parametar forms
What are the types of visual attribute settings?
What are the two ways to incorporate images into a oracle forms application?
Can you truncate a table in a procedure in Oracle Forms?
Explain master-detail relationship with some examples.
What are the trigger associated with image items?
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...
What is the use of image_zoom built-in?
What do you mean by a page ?
Oracle General 
