Home » Developer & Programmer » Reports & Discoverer » error using a formula column
error using a formula column [message #345394] Wed, 03 September 2008 06:46 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
i am trying to calculate sal / 12 in a formula column

so i said in my formula column

return (:sal / 12)

but it says bind variable sal is not allowed

function CF_1Formula return Number is
begin
  return (:sal / 12);
end;



Re: error using a formula column [message #345406 is a reply to message #345394] Wed, 03 September 2008 07:44 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
hello dear,
I what to know in which group your formula column field is?
Is it with same group of :sal field? and :sal is number field?
Are you getting any ora or rep error number with this?
Also give information about which version of report and database u using with which operating system.
Regards
Brijal
Re: error using a formula column [message #345409 is a reply to message #345394] Wed, 03 September 2008 07:50 Go to previous message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious: why are you calculating it using a formula? Why wouldn't you do that in report's query, such as
SELECT
  ename, 
  sal, 
  sal/12 salary_divided_by_12
FROM some_table
WHERE ...
Previous Topic: Character mode Print
Next Topic: How to design reports tat wil print details in Alternative page
Goto Forum:
  


Current Time: Sun Nov 10 05:00:00 CST 2024