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.

List out the oracle forms configuration files?

1005

---

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

1926

---

a text item is there what r the different types of triggers associated with it

1938

---

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

2858

---

Is it possible to have multiple layouts in a report?

967

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2250

---

what is difference between group above and group left report

3759

---

What is a canvas in oracle forms?

1008

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2048

---

What is the difference between bind and lexical parameter?

1010

---

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

1986

---

what is tripstop report?

1761

---

what is a package n what r the packages availbla in report

2034

---

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

1927

---

how to send file attachment from oracle forms

2489

---