Home » Developer & Programmer » Reports & Discoverer » Adding upto get 1 record (disc 10.1.2)
Adding upto get 1 record Thu, 18 June 2009 14:02
 aarti81 Messages: 235Registered: December 2007 Location: USA Senior Member
Hi All
```  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
 vamsi kasina Messages: 2108Registered: October 2003 Location: Hyderabad, India 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
 aarti81 Messages: 235Registered: 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
 cookiemonster Messages: 12818Registered: 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
 vamsi kasina Messages: 2108Registered: October 2003 Location: Hyderabad, India 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: Thu Aug 17 20:06:25 CDT 2017

Total time taken to generate the page: 0.08997 seconds