Home » Developer & Programmer » Reports & Discoverer » how can show formula in report
how can show formula in report [message #516648] Tue, 19 July 2011 18:16 Go to next message
hassan08
Messages: 122
Registered: June 2011
Location: egypt
Senior Member
i makes formula on the column in oracle forms
such as
column it's name
column1 and this column return value from another column column2
and used the
calculation mode = formula
formula = (:column1 + :column2)
the formula will be
(:column1 + :column2)
and this formula will appear in column3
how can show column3 in oracle report ?
Re: how can show formula in report [message #516668 is a reply to message #516648] Tue, 19 July 2011 23:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Almost the same way you do that in Forms - you'd create a "formula column" (you'll see it on the toolbar). Its code would be similar to Forms:
begin
  return (:column1 + :column2);
end;
Re: how can show formula in report [message #516700 is a reply to message #516668] Wed, 20 July 2011 02:29 Go to previous messageGo to next message
hassan08
Messages: 122
Registered: June 2011
Location: egypt
Senior Member
but when used the similar way in the report no thing happened
how can do this steps
Re: how can show formula in report [message #516701 is a reply to message #516700] Wed, 20 July 2011 02:34 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Steps" might depend on what you did so far so - provide some more information. What is a formula column supposed to do? What are its inputs - are they columns returned by report's query? Other formula columns? Parameters you passed to a report? Something different?

Did you read Reports Help on formula columns? If not, perhaps you should.

P.S. What does "nothing happened" mean? If there's no result, perhaps one of input values is NULL so, if you didn't handle that situation properly (such as using the NVL function), return value *might* be NULL as well.

[Updated on: Wed, 20 July 2011 02:35]

Report message to a moderator

Previous Topic: Rep-50125
Next Topic: REP-1219
Goto Forum:
  


Current Time: Thu Mar 28 14:05:13 CDT 2024