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
- 4156 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 a record Group?
Is it possible to attach same library to more than one form?
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 ?
How do you call other Oracle Products from Oracle Forms?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
did u p prepared complex report
What is the use of Printer Definition file (PRT) in Reports ?
What is the use of hidden column?
What is 4-way match?
what is procedure like symbols of bind and lexical
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
What is the usage of the confine mode in Layout Editor ?
Oracle General 
