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

how to pass 2 variables from one form to other form

2 Answers   Intelligroup,

---

Which is the cheapest and quality Oracle Education provider in Bangladesh?

1 Answers  

---

all steps of bitmap report?

0 Answers   Convergys,

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

State the order in which these triggers are executed ?

1 Answers  

---

How can a text file be attached to a report while creating in the report writer?

1 Answers  

---

how to send sms to mobile phone from oracle forms.

1 Answers   HP, Tech Mahindra,

---

When to use Place holder columns in Oracle Reports and what is a place holder column?

2 Answers  

---

What is the difference between bind and lexical parameter?

0 Answers  

---

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?

4 Answers   IBM,

---

How to change maximise or minimise the window in forms

4 Answers   Oracle,

---

What is a library?

1 Answers  

---