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........
Answer / 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 |
difference between repeating frame and frame
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.
How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base
what are bind variables?
what is the diffrence between before parameter form triger & formate trigger
How do you call other Oracle Products from Oracle Forms?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
What is strip sources generate options?
What is the advantage of the library?
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........
What is difference between open_form and call_form?
How many maximum number of radio buttons can you assign to a radio group?