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.
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 |
What are Most Common types of Complex master-detail relationships?
how do u run sql loader
LOV can best describe a) window b)modal c)list d) none of these d)
Explain the various types of oracle report?
Explain the different levels at which oracle form services interact.
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What is an user exit used for?
how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun
Is the After report trigger fired if the report execution fails?
What are the built-ins used for Getting cell values?
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 are the different types of Package Procedure ?