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 |
What is a user exit program in oracle reports?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through
Can you attach an lov to a field at run-time? if yes, give the build-in name.
what is oracle forms?
Is it possible to split the printpreviewer into more than one region?
did u p prepared complex report
Use the add_group_column function to add a column to record group that was created at a design time?
What is an OLE?
What are the built-ins used for finding Object ID function?
How you define procure to pay?
How do you pass the parameters from one form to another form?
how do u call a report from form