Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to repeat interim running total to next row Expand / Collapse
Posted Sunday, April 7, 2013 1:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 6, 2016 2:29 AM
Points: 45, Visits: 145

I think a fairly simple question, but I wonder how to do it in SSRS 2008 R2:
I have a table with recruitments and exits for personnel per week. Apart from that I have a starting value for the number of employees at the beginning of a year from another table.
I would like to have a report per week with a starting value for the no. of employees at that week, the recruitments and exits in that week and an ending value for the no. of employees. So, a matrix with weeks horizontally and starting value, recruitments, exits and ending value vertically. Starting value and ending value per week are calculated in the report (except from the initial starting value).
My point is how to repeat the ending value in a particular week to the starting value in the next week.

Can anybody tell me?

Post #1439662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse