Distinct Sum!

[skiabox]

I have designed a report with 2 tables and a view from an sql database.
In the detail section I have a field of the selection that is created by the report.That field is called 'bedaposo' and is a field from the view.
The view has a column with a key that is unique for every row of the view(like the candidate keys of tables).
The linking I have made with the linking expert brings me some rows with the same key.
I give an example here.
Original view :
bedakey bedaposo
12345 10
12346 5
12347 20
12348 30

query that is generated by the report :

bedakey bedaposo
12345 10
12345 10
12348 30
12349 35

I want to be able to generate by formula only and not by running total and grouping by the key a sum of the disticnt values of bedaposo.
In this example

10+30+35

Thank you!

[mrkorr]

I had the same problem.
After bouncing through the net i found this:

http://www.crystalconsulting.ca/faq.html

search for the "Creating Running Totals" section and follow the instructions.

[JaganEllis]

If you're not expecting the duplicates then maybe your linking is wrong.
You could also try ticking the Select Distinct Records option in the database menu.