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
- 4182 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we generate report output in excel format?
Name the different triggers associated with oracle forms having a master-detail relationship.
what exactly u write in when_new_form_instance
if u want to delete all these detail block etc what will happen in form
why the Ctl file u put only in bin folder why not in other folder
What is the difference between BPA AND Contract What are documents and test cases u followed
Explain the different levels at which oracle form services interact.
what is difference between group above and group left report
a text item is there what r the different types of triggers associated with it
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
how report can be generated if we have the database designed in oracle 10g?
What is a matrix report and how many minimum groups are required to prepare the same?
What are the various configuration files that are used by oracle forms?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
