Home » Developer & Programmer » Reports & Discoverer » Reference columns from different groups in formula column (Reports 6i)
Reference columns from different groups in formula column [message #279109] Wed, 07 November 2007 00:21 Go to next message
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
Re: Reference columns from different groups in formula column [message #279316 is a reply to message #279109] Wed, 07 November 2007 14:53 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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:

./fa/3363/0/

This is the output; no error here:

./fa/3364/0/

Could you explain what and how you did that (possibly differently from me) so that it didn't work properly?
Re: Reference columns from different groups in formula column [message #279966 is a reply to message #279316] Mon, 12 November 2007 02:05 Go to previous message
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
Previous Topic: How To Return To PARAMETER FORM
Next Topic: What is the Latest Patch Available for Reports 6i
Goto Forum:
  


Current Time: Tue Dec 06 15:53:03 CST 2016

Total time taken to generate the page: 0.08975 seconds