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
- 5067 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 |
How do you control the constraints in forms ?
When is PRE-QUERY trigger executed ?
What do you mean by a page ?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
EXIT_FORM is a restricted package procedure ?
Can a root window be made modal?
Can we use bulk collect in oracle forms if yes then how?
What are the vbx controls?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base
What are Most Common types of Complex master-detail relationships?
Oracle General 
