1. Categories >> Software >> Databases >> Oracle >> Oracle Forms Reports
  2. Suggest New Category

in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........

Question Posted / tech knit

Answer Posted / tech knit

first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null

and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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...

1682

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

847

What do we mean by record group in oracle forms?

618

What do you understand by lov and how can it be used?

585

What is responsibility and how u attach How to create user and how u attach with responsibility.

1629




what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

603

Is it possible to execute a dynamic sql from forms?

606

if u want to delete all these detail block etc what will happen in form

1484

In what sequence do triggers get fired by oracle forms?

543

Is it possible to have multiple layouts in a report?

582

what exactly u write in when_new_form_instance

2902

all steps of bitmap report?

1912

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2472

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

1867

what are the oracle forms services components include?

566