Home » Developer & Programmer » Reports & Discoverer » call colum formula resume
call colum formula resume [message #202967] Mon, 13 November 2006 07:56
thepunisher_oracle
Messages: 3
Registered: November 2006
Location: spain
Junior Member
hello,

i have a question from my report.

I need to call colum formula from other types of formula can support the report.

Example:

I have the next formula colum in the data model (is not in the data model group, group query):

function cambiaparam2Formula return Number is
variable number;
var2 number;
begin
variable:=0;
:parametro2:=2;
-- parameter user.
return variable;
end;

this function changes a user parameter, this parameter is use to control a query (see the next post i wrote, is about it : http://www.orafaq.com/forum/t/71975/2/)

I need to call, use from other functions are contains in unit attached library and formula group.

There are the other functions:

(formula group)

function CF_1Formula return Number is
valor number;

begin

UnitParameter(:cod);
--call the unit function with parameters.
end;

(formula unit)

FUNCTION DAME_PARAM2(cod number) RETURN NUMBER IS
var number;
BEGIN
if (cod = 23) then
var:=2;
:parametro2:=3;
end if;
cambiaparam2;
-- here to call (column formula -> cambiaparam2)
END;

and the select....

select cod
from table where cod=34 and parametro2:=3;

Any idea to do this...

How to call a external functions in the data model, in the part of the query.....??

Thank very much. Razz


Previous Topic: image on report
Next Topic: Like carryforward of sum out of balance
Goto Forum:
  


Current Time: Sun Dec 04 15:06:40 CST 2016

Total time taken to generate the page: 0.11060 seconds