Answer Posted / 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.

How can we generate report output in excel format?

1036

---

What is a user exit program in oracle reports?

1078

---

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

2024

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1205

---

In what sequence do triggers get fired by oracle forms?

1016

---

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

4614

---

what are the new features introduced in oracle form services in 11g release 2?

1075

---

In what situation u create the BPA.

2248

---

What do we mean by record group in oracle forms?

1127

---

List out the oracle forms configuration files?

1124

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2278

---

Explain the different levels at which oracle form services interact.

1103

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3319

---

what are bind variables?

1140

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2290

---