OraFAQ Forum: Reports & Discoverer » Adding upto get 1 record

Home » Developer & Programmer » Reports & Discoverer » Adding upto get 1 record (disc 10.1.2)

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

Adding upto get 1 record [message #409014]

Thu, 18 June 2009 14:02

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Hi All
Please view the following records:

  cal1                         cal2                          cal3
A & F E	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	 $ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000
 	$ 195,336,400	$ 15,632,600	$ 40,500,000

Cal1 cal2 cal3 are calculated fields based on three other calculation
calc1:SUM(Calculation71) OVER(PARTITION BY Primes Subs with BUY INDIANA.Firm Name )

What i want is to see them as one record, is there any way possible? Please need help.

A & F E $ 195,336,400 $ 15,632,600 $ 40,500,000

Thanks

Report message to a moderator

Re: Adding upto get 1 record [message #409015 is a reply to message #409014]

Thu, 18 June 2009 14:18

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

I'm confused!
Are these in a repeating frame?
When you say

Quote:

Cal1 cal2 cal3 are calculated fields based on three other calculation

Is that mean they have been calculated by summary columns? (Or) any select?

If it is select post that here. I think you can have a group by in that case.

By
Vamsi

Report message to a moderator

Re: Adding upto get 1 record [message #409020 is a reply to message #409015]

Thu, 18 June 2009 14:47

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Vamsi please see the below report:

                  CALC1        CALC2       CALC3
A & F Engineering Co., LL $ 70,000,000	
 	                  $ 20,000,000		
 	                  $ 22,500,000		
 		                       $ 750,000	
 		                       $ 5,051,000	
 		                       $ 8,081,600	
 			                            $ 40,500,000
 	                  $ 82,836,400		
 		          $ 1,750,000

My question is how can you add up these records into one amount per each column,
Must see something like this :

Name       CALC1       CALC2     CALC3
A&F Co     $195336400  $13882600 $40500000

Hope you understood?
Thanks

Report message to a moderator

Re: Adding upto get 1 record [message #409034 is a reply to message #409014]

Thu, 18 June 2009 17:33

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

use sum and group by

Report message to a moderator

Re: Adding upto get 1 record [message #409046 is a reply to message #409020]

Thu, 18 June 2009 23:51

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

What did you do before to get those 15 similar rows?
Without having your report select sql, we can't do much.

By
Vamsi

Report message to a moderator

Previous Topic:	Interesting Conditional Formatting Problem
Next Topic:	Resseting Place Holder Value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:44:58 CDT 2024