Problems with the sum function in the reporting services -- sql server reporting services

LUIS
11/30/2006 4:02:05 AM

Pleas help me!

Following Problem:

I cant get a sum of the group Value.

For example my Table:

Date ID KM_from KM_to Sum_KM ID2 Text
cost
20061001 1 100 200 100 1_1
taxi 100
20061001 1 100 200 100 1_2
hotel 200
20061001 1 100 200 100 1_3
meat 80
20061002 2 200 400 200 2_1
hotel 150

In the Reporting Services i grouped the values by Date and ID. But when
i want to get the sum of (Sum_KM) there comes the value 500. Thats
wrong. The right Value is 300. So how can i get the right sum of KM. It
sums all Values.

Thanks for help

Chris Conner
12/3/2006 10:06:34 PM

Whatever the name of your group is, be sure to specify that in the scope.

i.e.

=SUM(Fields!Sum_KM.Value, "GroupNameGoesHere")

[quoted text, click to view]

sql server reporting services : Problems with the sum function in the reporting services