Cumulating

hi,
I have a table that gives me lets say : DateReachingPlace, PlaceCityName,
MilesSincePreviousPlace
How could I have a cumulative field for Mileage ?
DataSet:
17:00 Paris 5
17:30 Clichy 7
17:45 LaDefense 11
Expected report:
17:00 Paris 5 5 //(assuming it is the first record)
17:30 Clichy 7 12 //(5+7)
17:45 LaDefense 11 23 //(12+11)
Regards
jRTry this expression: =RunningValue(Fields!MilesSincePreviousPlace.Value,
Sum, Nothing).
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jcredk" <jcredk@.discussions.microsoft.com> wrote in message
news:2872D4D2-DE26-4F3C-9B79-9E1B176A410C@.microsoft.com...
> hi,
> I have a table that gives me lets say : DateReachingPlace, PlaceCityName,
> MilesSincePreviousPlace
> How could I have a cumulative field for Mileage ?
> DataSet:
> 17:00 Paris 5
> 17:30 Clichy 7
> 17:45 LaDefense 11
> Expected report:
> 17:00 Paris 5 5 //(assuming it is the first
record)
> 17:30 Clichy 7 12 //(5+7)
> 17:45 LaDefense 11 23 //(12+11)
> Regards
> jR
>