Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

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

2858


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1233


what is a package n what r the packages availbla in report

2035


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1172


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

1931


did u received a single file or multiple files

1971


how to send file attachment from oracle forms

2489


Explain how can you use the same lov for 2 columns?

1079


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1928


difference between global n context sensitive segments?

2630


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1934


How can we expand Parameter Form Canvas on Reports 6i?

2365


what is difference between group above and group left report

3760


what exactly u write in when_new_form_instance

3378


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1089