Home » Developer & Programmer » Reports & Discoverer » How can i use formula column and place holder column?
How can i use formula column and place holder column? [message #178622] Wed, 21 June 2006 21:29 Go to next message
ratraau
Messages: 1
Registered: June 2006
Location: Florida
Junior Member

Hi Friends
I am new Oracle Reports
Can u please tell about formula columns and place holder columns? How can we use in reports? can u show me using emp table or .. Please?
Thanks
Re: How can i use formula column and place holder column? [message #188902 is a reply to message #178622] Tue, 22 August 2006 05:46 Go to previous message
rana.irfan@arzootex.com
Messages: 15
Registered: June 2006
Location: Faisalabad.
Junior Member

hi,

SELECT ALL EMP.EMPNO, EMP.ENAME,
EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM EMP

Now we Required Department Name against Emp.DeptNo.
for this we required Formula column.

function CF_1Formula return Char is
A varchar2(50);
begin
select Dname Into A from Dept
where deptno=:deptno;
Return A;

end;


Placeholder.

Click placeholders column and put in query and then

function CF_1Formula return Char is
A varchar2(50);
begin
select Dname Into A,:CP_1 from Dept
where deptno=:deptno;
Return A;

end;
Note :CP_1 is placeholder column that is used as a variable.
sorry for my weak English writing.

Regards,

Rana Irfan
Previous Topic: extra page inreport
Next Topic: Form Letters
Goto Forum:
  


Current Time: Sun Dec 04 02:53:16 CST 2016

Total time taken to generate the page: 0.06369 seconds