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
- 5151 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 User-Named Editor?
What are display items?
What is the built_in routine used to count the no of rows in a group?
What are the various sub events a mouse double click event involves?
what is tripstop report?
hiding item in report how like that properly,thats manually but at runtime i want to do
What are the vbx controls?
When is PRE-QUERY trigger executed ?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
What is the difference when Flex mode is mode on and when it is off?
What is the difference between boiler plat images and image items?
in before report trigger SRW.user_exit(FND_Userinit) what will do
Oracle General 
