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.

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

3252

---

In what sequence do triggers get fired by oracle forms?

973

---

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

1992

---

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

2129

---

What is an oracle report?

1086

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2990

---

Is it possible to have multiple layouts in a report?

1036

---

What is an SQL FORMS ?

2799

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2168

---

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

1040

---

what are the oracle forms services components include?

1037

---

if some data is not transfered where it will get stored

1950

---

Is it possible to execute a dynamic sql from forms?

1081

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1702

---

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

2046

---