Answer / sudipta santra

1. In Report's Data model part, click on Placeholder column
from toolbox, then a placeholder column will be created with
default name CP_1 as like if u want u can change the name.
2. Go to the PL/SQL by right clicking on the newly created
placeholder column in data model.
function CP_1Formula return char
begin
return null;
end;
3. Click on Formula column from toolbox, then a formula
column will be created with the default name CF_1/CF_2 as
like that, if u want u can change it's name.
4. Go to the PL/SQL by right clicking on the newly created
formula column in data model.
function CF_1Formula return number
begin
if :stock<10 then
:CP_1:= 'Too less stock';
elsif :stock<50 and :stock>10 then
:CP_1:= 'Average stock';
else
:CP_1:= 'Good stock';
end if;
return 1;
end;

Note: Here the placeholder column is used with the null
carrying result but when the formula be used then the
placeholder will get value and will carry this in report.
And also we can use this anywhere in report as according
application requiremnt needs.

Answer / sikdar

1.To create a column within a group, click in the group at
the position you want the column placed in the hierarchy.
To create a report-level column, click in an open area of
the canvas region
2. Double-click the placeholder column object.
3. In the Property Inspector, set the desired
properties for the placeholder column.
4. Set the value of a placeholder column in

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 Answers  

---

What is a library in Forms 4.0?

1 Answers  

---

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 Answers  

---

What is an SQL FORMS ?

0 Answers   Verizon,

---

How to call a report from Forms?

5 Answers  

---

Can a formula column be obtained through a select statement?

1 Answers   TCS,

---

How many Flexfields are there in AR and what are they ?

1 Answers  

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?

1 Answers  

---

When will ON-VALIDATE-FIELD trigger executed ?

1 Answers  

---

What is the use of Page Protect Property?

1 Answers   GE,

---

I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.

1 Answers  

---

What is the usage of frame ?

1 Answers   Convergys,

---