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.
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
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
what is a package n what r the packages availbla in report
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
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
did u received a single file or multiple files
how to send file attachment from oracle forms
Explain how can you use the same lov for 2 columns?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
difference between global n context sensitive segments?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How can we expand Parameter Form Canvas on Reports 6i?
what is difference between group above and group left report
what exactly u write in when_new_form_instance
What is an implicit anchor and how is it a different form explicit anchor in a report builder?