OraFAQ Forum: Reports & Discoverer » error using a formula column

Home » Developer & Programmer » Reports & Discoverer » error using a formula column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error using a formula column [message #345394]

Wed, 03 September 2008 06:46

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;

Report message to a moderator

Re: error using a formula column [message #345406 is a reply to message #345394]

Wed, 03 September 2008 07:44

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

Report message to a moderator

Re: error using a formula column [message #345409 is a reply to message #345394]

Wed, 03 September 2008 07:50

Littlefoot
Messages: 21808
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 ...

Report message to a moderator

Previous Topic:	Character mode Print
Next Topic:	How to design reports tat wil print details in Alternative page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 21:28:46 CDT 2024