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
- 4387 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
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
Explain the different levels at which oracle form services interact.
Can we invoke one form from another in a multi-forms application?
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
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
did u p prepared complex report
How can we expand Parameter Form Canvas on Reports 6i?
if u want to delete all these detail block etc what will happen in form
What do you understand by oracle forms and why are they required?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
what is difference between group above and group left report
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
Explain how can you use the same lov for 2 columns?
Name the different triggers supported by oracle reports and their firing order.
