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.
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
List the different types of columns in oracle reports.
how do u compile a form i.e .fmb file in Unix or in dos
Why oracle forms required?
Name the different triggers supported by oracle reports and their firing order.
all steps of bitmap report?
What is an SQL FORMS ?
Name the different triggers associated with oracle forms having a master-detail relationship.
In what situation u create the BPA.
did u p prepared complex report
What do you understand by lov?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
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?
Is it possible to have multiple layouts in a report?
Explain how can you use the same lov for 2 columns?