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
- 4306 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 |
sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?
What is the difference between keystartup and pre-form ?
How can we expand Parameter Form Canvas on Reports 6i?
Can a field be used in a report wihtout it appearing in any data group?
where do u put the report file
What is a canvas-view?
if u have one group can u create another from that
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
What are the sql clauses supported in the link property sheet?
what are difference between post database commit and post-form commit?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
What is the usage of the Flex mode in Layout Editor ?
Oracle General 
