OraFAQ Forum: Reports & Discoverer » Reference columns from different groups in formula column

Home » Developer & Programmer » Reports & Discoverer » Reference columns from different groups in formula column (Reports 6i)

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

Reference columns from different groups in formula column [message #279109]

Wed, 07 November 2007 00:21

sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi

Member

Salam

i have 2 different groups "G_prod1" and "G_prod2" in data model
both of group have 1 column "column1" and "colum1"i want to minus column2 from column1 in a formula column in "G_prod2"
which report developer dosn't allow
displaying a message of incompatible frequency

anyone's help will be appreciated.

Regards
Kashif Ali

Report message to a moderator

Re: Reference columns from different groups in formula column [message #279316 is a reply to message #279109]

Wed, 07 November 2007 14:53

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I've created a sample report based on Scott's schema. There are two queries:

-- QUERY 1
SELECT empno, ename, sal
FROM emp

-- QUERY 2
SELECT empno, comm
FROM emp

I created a data link between them, linking 'empno' columns.

Also, I've created a formula column in the second group which returns sum of 'sal + comm':

function CF_1Formula return Number is
begin
  return (:sal + :comm);
end;

This is the Data Model:

/forum/fa/3363/0/

This is the output; no error here:

/forum/fa/3364/0/

Could you explain what and how you did that (possibly differently from me) so that it didn't work properly?

Attachment: formula_1.PNG
(Size: 5.07KB, Downloaded 1410 times)
Attachment: formula_2.PNG
(Size: 9.71KB, Downloaded 1413 times)

Report message to a moderator

Re: Reference columns from different groups in formula column [message #279966 is a reply to message #279316]

Mon, 12 November 2007 02:05

sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi

Member

thanks a lot brother,
u have solved my problem
actually i was trying to insert value from formula column to placeholder column and when i did't use placeholder column it worked

once again thanks

Report message to a moderator

Previous Topic:	How To Return To PARAMETER FORM
Next Topic:	What is the Latest Patch Available for Reports 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:51:10 CDT 2024