Home » Developer & Programmer » Reports & Discoverer » Adding upto get 1 record (disc 10.1.2)
Adding upto get 1 record [message #409014] Thu, 18 June 2009 14:02 Go to next message
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



Re: Adding upto get 1 record [message #409015 is a reply to message #409014] Thu, 18 June 2009 14:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Re: Adding upto get 1 record [message #409020 is a reply to message #409015] Thu, 18 June 2009 14:47 Go to previous messageGo to next message
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
Re: Adding upto get 1 record [message #409034 is a reply to message #409014] Thu, 18 June 2009 17:33 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
use sum and group by
Re: Adding upto get 1 record [message #409046 is a reply to message #409020] Thu, 18 June 2009 23:51 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: Interesting Conditional Formatting Problem
Next Topic: Resseting Place Holder Value
Goto Forum:
  


Current Time: Mon Dec 05 04:38:38 CST 2016

Total time taken to generate the page: 0.08796 seconds