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
- 5023 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 |
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
what are the new features introduced in oracle form services in 11g release 2?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
How i get the client m/c IP address.
When do you use data parameter type?
what is the difference between call_form, new_form and open_form?
what are the oracle forms services components include?
How we can migrate the 6i report to 10g reports. What steps need to reuired?
Explain how one can iterate through items and records in a specified block?
What is Post-Block?
how do u run sql loader
Oracle General 
