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

What does an on-clear-block Trigger fire?

1 Answers  

---

how report can be generated if we have the database designed in oracle 10g?

0 Answers  

---

Use the add_group_column function to add a column to record group that was created at a design time?

2 Answers  

---

what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 Answers  

---

Name the two files that are created when you generate the form give the filex extension ?

2 Answers  

---

What is the frame & repeating frame?

1 Answers  

---

List out the oracle forms configuration files?

0 Answers  

---

What is an oracle report? List its various types.

0 Answers  

---

What is a canvas in oracle forms?

0 Answers  

---

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 Answers  

---

What are the types of trigger actions?

4 Answers   Zensar,

---

What is a Non Query Record Group?

1 Answers  

---