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
- 4472 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
How can we generate report output in excel format?
Explain the different levels at which oracle form services interact.
hiding item in report how like that properly,thats manually but at runtime i want to do
what are bind variables?
what is a package n what r the packages availbla in report
all steps of bitmap report?
What is the difference between flex mode and confined mode?
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 is a matrix report and how many minimum groups are required to prepare the same?
what is difference between group above and group left report
What is an oracle report?
What is an oracle report? List its various types.
what exactly u write in when_new_form_instance
In what situation u create the BPA.
