i created a parameter list in reports. how to restrict that
parameter list with parameters
Answer Posted / upendra kumar sharma
The Restrict List to Predetermined Values is a checkbox
that indicates whether a value for the parameter must be in
the list of values. For example, if you check Restrict
List to Predetermined Values and the Initial Value does not
match a value in the list of values, an error will be
generated when you accept the Parameter property sheet.
Similarly, if you set a value for the parameter on the
command line or in a command script and it does not match a
value in the list of values, an error will be generated
when the report is run. If you check Restrict List to
Predetermined Values, a list of values will appear in the
runtime parameter form. If you do not check it, a combo
box will appear (i.e., you can enter values as well as
select from the list).
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What do you understand by oracle forms?
List the different types of columns in oracle reports.
difference between global n context sensitive segments?
What are the various configuration files that are used by oracle forms?
from where do u receive the information to develop report
Is it possible to have multiple layouts in a report?
a text item is there what r the different types of triggers associated with it
What is an oracle report?
What is a user exit program in oracle reports?
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
can you convert or reverse engineer a fmx back to a fmb file?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What is the difference between flex mode and confined mode?
What is responsibility and how u attach How to create user and how u attach with responsibility.
Name the different triggers associated with oracle forms having a master-detail relationship.