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


Please Help Members By Posting Answers For Below Questions

What do you understand by oracle forms?

575


List the different types of columns in oracle reports.

558


difference between global n context sensitive segments?

2193


What are the various configuration files that are used by oracle forms?

550


from where do u receive the information to develop report

1521






Is it possible to have multiple layouts in a report?

565


a text item is there what r the different types of triggers associated with it

1502


What is an oracle report?

596


What is a user exit program in oracle reports?

563


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

1282


can you convert or reverse engineer a fmx back to a fmb file?

692


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

621


What is the difference between flex mode and confined mode?

519


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

1611


Name the different triggers associated with oracle forms having a master-detail relationship.

491