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
- 4395 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 |
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
What the PAUSE package procedure does ?
What is an oracle report? List its various types.
What is the advantage of the library?
explain tkprof?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
what r the various types of reports
What are the different types of Delete details we can establish in Master-Details?
What is the "LOV of Validation" Property of an item? What is the use of it?
How do you pass the parameters from one form to another form?
What is difference between open_form and call_form?
What is a Trigger ?
Oracle General 
