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.

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1986

---

if u want to delete all these detail block etc what will happen in form

1989

---

what is the difference between call_form, new_form and open_form?

1309

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1978

---

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

1039

---

from where do u receive the information to develop report

2012

---

can you convert or reverse engineer a fmx back to a fmb file?

1164

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2041

---

What do you understand by lov?

1037

---

What is a canvas in oracle forms?

1066

---

Can we invoke one form from another in a multi-forms application?

1133

---

what is tripstop report?

1836

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2906

---

why the Ctl file u put only in bin folder why not in other folder

2048

---

List out the oracle forms configuration files?

1073

---