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 |
When to use Place holder columns in Oracle Reports and what is a place holder column?
Two popup pages can appear on the screen at a time ?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
what is procedure like symbols of bind and lexical
why the Ctl file u put only in bin folder why not in other folder
What is forms_DDL?
How can you create Lexical parameter n Bind parameter in Reports ?
How do you pass the parameters from one form to another form?
Is it possible to split the printpreviewer into more than one region?
.fmb will be in which folder
how do u call a report from form
What are the different window events activated at runtimes?