i created a parameter list in reports. how to restrict that
parameter list with parameters
Answer / 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 |
Name the two files that are created when you generate the form give the filex extension ?
What is the maximum size of a form ?
What is a timer?
What is an SQL FORMS ?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/
What use of command line parameter cmd file?
how to call forms in parametar forms
An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
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
how report can be generated if we have the database designed in oracle 10g?