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 are the various configuration files that are used by oracle forms?
What is the difference between BPA AND Contract What are documents and test cases u followed
In what sequence do triggers get fired by oracle forms?
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
Is it possible to execute a dynamic sql from forms?
Explain how can you use the same lov for 2 columns?
can you convert or reverse engineer a fmx back to a fmb file?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What do you understand by oracle forms and why are they required?
hiding item in report how like that properly,thats manually but at runtime i want to do
if u want to delete all these detail block etc what will happen in form
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
Explain the various types of oracle report?
from where do u receive the information to develop report
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.