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
- 4273 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
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is the difference between flex mode and confined mode?
can you convert or reverse engineer a fmx back to a fmb file?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
difference between global n context sensitive segments?
what are the new features introduced in oracle form services in 11g release 2?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
In what situation u create the BPA.
What do you understand by oracle forms and why are they required?
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?
How can we generate report output in excel format?
What is the difference between BPA AND Contract What are documents and test cases u followed
Name the different triggers supported by oracle reports and their firing order.
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
