i created a parameter list in reports. how to restrict that
parameter list with parameters
- 1 Answers
- 5698 Views
- iFlex, I also Faced
- E-Mail Answers
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
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
How to create Drill down report?
did u p prepared complex report
why the Ctl file u put only in bin folder why not in other folder
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.
What is an oracle report? List its various types.
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
What is an SQL FORMS ?
what is difference between group above and group left report
what is the difference between call_form, new_form and open_form?
hiding item in report how like that properly,thats manually but at runtime i want to do
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
List out the oracle forms configuration files?
Explain the different levels at which oracle form services interact.
