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 can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,

---

WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?

1 Answers   TATA, TCS,

---

What built-in is used for changing the properties of the window dynamically?

1 Answers  

---

How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.

1 Answers  

---

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

1 Answers   Azri Solutions,

---

What are the different modals of windows?

1 Answers  

---

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

1 Answers  

---

What is AppCore and AppCore2 ?

1 Answers  

---

Can we create two blocks with the same name in form 3.0 ?

1 Answers  

---

What are the various methods of performing a calculation in a report ?

1 Answers  

---

how will the report recognize the parameter

1 Answers  

---

What are the different types of Coordinations of the Master with the Detail block?

2 Answers  

---