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
- 4978 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 use of image_zoom built-in?
what are Navigational Triggers?
What is the built-in used for showing lov at runtime?
How can we expand Parameter Form Canvas on Reports 6i?
What is a record group?
Which parameter can be used to set read level consistency across multiple queries?
Can a property clause itself be based on a property clause?
EXIT_FORM is a restricted package procedure ?
Can you change the alert messages at run-time?
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 are different types of canvas views?
Oracle General 
