Answer Posted / deepak

add one more parameter in your form

syntax:
Add_parameter
(<param_list>,<parma_variable>,<parameter_type>,<parameter_v
alue>);

Example:
add_parameter(pi_id,'PARAMFORM',TEXT_PARAMETER,'NO');
---------------------------------

note:

Dont change underline parameter.

How can we generate report output in excel format?

996

---

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

1694

---

What is an SQL FORMS ?

2788

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1979

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1018

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2021

---

What is a matrix report and how many minimum groups are required to prepare the same?

1139

---

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

2038

---

what are the oracle forms services components include?

1023

---

how to send file attachment from oracle forms

2549

---

how do u compile a form i.e .fmb file in Unix or in dos

4569

---

why the Ctl file u put only in bin folder why not in other folder

2044

---

where do u put the report file

2091

---

Explain how can you use the same lov for 2 columns?

1128

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2124

---