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
- 4352 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghav
first create a sql query in the data model like below
select empno from emp no where deptno=:p_deptno.run the
report
| Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
What are the two panes that Appear in the design time pl/sql ?
What are all the system Parameters available in ORACLE Reports
What are the built_in used to trapping errors in forms 4?
What built-in is used for showing the alert during run-time?
How many types of trigger can be used in a table at a time ?
What are the built-ins that are used for setting the LOV properties at runtime?
What is the use of transactional triggers?
What is a Text_io Package?
What is the difference between BPA AND Contract What are documents and test cases u followed
what is a display item?
Oracle General 
