While Summing how to eliminate the supressed duplicate values

[CrystalReports9]

After select the option "Suppress If Duplicated" if i did summation it summing all the data, including duplicate value.

But i Need to sum only the displaying unique records alone in the report after choose "suppress if duplicated" option.

Question
--------
How 2 eliminate the
duplicate values while summing AND
Groupwise sale total AND
Grand sale Total

Example
-------
// Column name is SALE - Grouping on DISTRICT

District : 10

Sale
----
1000
1000
2000
1000

After suppress the duplicate my report should be like the following:

District : 10

Sale
----
1000

2000

---- <--- How 2 get this total????
3000
----
District : 20

Sale
----
1000



---- <--- How 2 get this total????
1000
----

Grand Total: 4000 (1000 + 3000)

How 2 set this grand total also????


Pls help meeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

Rgs
Anto

 

[Transcend]

Add another group on the sale field and put the
data into the group header or footer, this should give
you what you need.

Transcend

 

[CrystalReports9]

Hi Transcend

Pls give me tips in detail....Pls....Thank u

Rgs
Anto

 

[rosemaryl]

Anto,

What field, is causing the rows to &quot;duplicate&quot;?

Create a group on that field and move your values up to the group. Suppress details all together.

Now you can create running total tot sum.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Transcend]

You already have a grouping on District on your report yes?
Add another group to your report on the sales field, and put the data of the report into the sales group header or sales group footer, then create your running total and you should get the result that you want.

Transcend